Amazon S3 Upload Tool: Suffix added to upload filename? Default or can it be removed?

[ctanawath]

Long time lurker, first time poster!

I created a app/workflow to upload the final data set to an S3 Bucket as a .csv.  As part of the app, you have to specify a name for the file to be uploaded (via textbox and action interface tool) to the S3 bucket.  The expected results is something like this: "MM-YYYY-Filename.csv",  what I end up with is "MM-YYYY-Filename/alteryx-override/2022-11-16 14:52:07.csv".  Can the "alteryx-override/2022-11-16 14:52:07.csv" be removed or not added, or is that a default that has to stay?

Thanks,

C.

[IraWatt · Accepted solution]

Hey @ctanawath,

Plenty of ways to do this. One way is just to just update with formula and use regex to remove all the path before the file name:

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

[ctanawath]

The file name input works, but it's when it gets uploaded to the S3 bucket, the ""alteryx-override/2022-11-16 14:52:07" gets added into the file name in the upload.  I attached the upload part. 

[apathetichell]

either your output tool is configured wrong (replace entire path - not append the field to the filename) or your action tool/formula interaction isn't doing what you want. you want to to replace a value with a formula - and then you need to build your new name as something like datetimeformat([#1],"%m+%Y")+"Filename.csv"

You have your base filename set up in formation as "MM-YYYY-Filename.csv" and your action tool highlighting this.

[ctanawath]

There is no output tool, it's a Union tool directly connected to the S3 bucket for upload.  I did a couple more test uploads and have narrowed down to the configuration  of the interface Text Box and the Action tools.  Does anyone know what option I need to configure within the tool to not include the "//alteryx-override/*timestamp*" suffix addition?

[ctanawath]

I think I may have figured something out!  To be updated!