Alteryx Designer Desktop Discussions

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

Multiple files upload to Amazon S3 Upload

Saravanakumar
7 - Meteor

Is it possible to upload all the files in a folder to be uploaded to Amazon S3? I have 10 csv files trying upload all at once. Please suggest.

2 REPLIES 2
DanM
Alteryx Community Team
Alteryx Community Team

@Saravanakumar you can create a batch macro in conjunction with a Directory tool. In the Directory tool choose the folder where your files are located. Use the Full Path field as your control parameter for the batch macro. Have the Full Path field update an Input tool in the batch macro and have an Output immediately after connected to your Amazon S3 database.

 

Workflow attached as a sample of configuration of the tools. You can see the inside of the macro if you select the macro, right click, and choose open macro. You will have to configure both the Input (as a template to your files) and configure the Output. You may need to configure the Output tool to handle each file.

 

If you are looking to not batch each file separately and create one file with all the data from the files. You can modify the macro and use a Macro Output instead of the Output Tool which will Union all of your data on top of each other. You can then attach an Output tool to the macro and send your data to Amazon. 

Saravanakumar
7 - Meteor

Thank you so much. It worked perfectly.

Labels