Creating macro to update output filename to s3 dynamically

[rimaissa]

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?

[Qiu]

@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-D...

[rimaissa]

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]

@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.