How to run a workflow on every file in a folder?

I have a simple workflow that takes large CSV files of accounts and payments and nets them together. I have about 30 files sitting in a folder I need to run this workflow on. I tried using the * symbol in my input file tool, but that just added them all to one file. Each file needs to go to its own output.

Can I wrap my workflow in something to make it run from start to finish for each file one after another?

Tips and Tricks

Accepted answers

dougperez

You can use the * to add all files into one flow with filename as a input, then separate then using the filename in the output (pass this field as file/table name

Input:

Output:

All comments

Luke_C

Hi @abragg0103

It depends on how things are being processed, but there are two approaches:

In the input, read in the file name (option 4 in the input tool). Then use this file name to group the data as it goes through the workflow and leverage it in the output to split the files.
Leverage a batch macro to process each file individually.

dougperez

You can use the * to add all files into one flow with filename as a input, then separate then using the filename in the output (pass this field as file/table name

Input:

Output:

messi007

@abragg0103,

You have to use a batch macro :

Please see below :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Batch-Macro-Input-for-csv/td-p/743592

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/CSV-Batch-Macro-Error/td-p/754124

Hope this helps!

Regards

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703