Creating macro to update output filename to s3 dynamically

Question

Hello,

Trying to get a macro built to get my output filename to s3 append the date so it doesn't overwrite the previous record when scheduled. I attached a workflow below. I'm unsure which formula I should use in the Action tool to get the filename to append the date. I've tried "filename"+DateTimeNow() but when I run the workflow it doesn't append the data.

Any ideas?

test.yxmc

Qiu · Answer

@rimaissa

For the control parameter tool, we have to connect with some string that is the file you are inputting.

Sorry I can not really test for you since no AWS account.

rimaissa · Answer

Hi @Qiu ,

Thanks for the reply! I'm confused on what I need to add to the formula of the action tool:

It just errors and says unknown variable.

Qiu · Answer

@rimaissa

I think we should use a formula tool to form the required before before the upload tool.

I dont have an AWS account, so sorry can not really test it.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Amazon-S3-Upload-and-Download/ta-p/344598

test.yxmc