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

[abragg0103]

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?

[Luke_C]

Hi @abragg0103 

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

1. 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.
2. Leverage a batch macro to process each file individually. 

[dougperez · Accepted solution]

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