In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ctanawath
5 - Atom

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.

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

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:

IraWatt_0-1668629724040.png

IraWatt_0-1668629797927.png

 

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
5 - Atom

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
19 - Altair

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
5 - Atom

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
5 - Atom

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

Labels
Top Solution Authors