How to add the current date to file name while uploading a file to s3 bucket using alteryx

Question

I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can anyone help me with this?

varun_sub · Answer

Hello Dan,

Thanks for the link. I did refer it. I am very new to Alteryx so please don't mind the question. So for the macro input tool the file input location would be the s3 file location and for the action tool we would have to select the update with formula option for the object and add the formula for the current date. Can you please tell me if this is the correct approach?

Regards,

Varun

danilang · Answer

Hi @varun_sub

There's no way to update the output object name in the main workflow, but you can do it in a batch macro.  Look at the solution from @CharlieS in this post

Dan