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

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.

Amazon S3

Accepted answers

IraWatt

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%20Data

Workflow.yxwz

All comments

IraWatt

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:

Workflow.yxwz

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.

image.png

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703