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?
Solved! Go to Solution.
Hi @abragg0103
It depends on how things are being processed, but there are two approaches:
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:
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