Hi All,
Im trying to create a workflow wherein all files in my 1st input data tool will run in the attached workflow; next it has to create a file for each output file.
Appreciate the help
Hi @jogayon001 ,
If you need to execute your workflow one file by one where you generates and output each way your workflow runs, the best approach is to use a batch macro.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165?search-action-id=57639173602&search-result-uid=488165
The idea is for you to have a workflow where you get all the files names and you insert in your batch macro (your workflow which some tweaking) which will run for each filename you insert. I'm attaching an example to show you how.
Best,
Fernando Vizcaino
The first thing you need to do is to configure your input data tool as image below. Using that configuration, you bring as a column the name of each file loaded.
After that, you need to carry that column until your output data tool where you configure as image below. The idea is for you to create a different file for each [FileName] you have in your dataset. So instead of [Registration name], you need to use the filename for each file.
Let me know how that goes.
Thanks fmvizcaino, that was useful.
Also, my challenge is to put all of these files in a loop. What could be the best approach?
