This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am a newbie to Alteryx and after a week of looking to solve this problem on my own i realized that I need some help.
I am looking to run a process for each file and then have a final output appending all the outcomes of each individual file run.
On my first workflow I need to change the Input Data connection for each file to run,
After some online searching I found out about the batch macros that technically would solve my problem, then I added the Incoming Control Parameter to specify the location of the files I need to process individually and Outcoming Control Parameter with the location for the outputs.
The issue is that the process is bringing all the files at once to process instead of processing one file at a time and output the result, look for the following, process and output…. (Looping the process through all the files).
I have done things like this before. You might want to explore using the directory tube to bring in all the files in a particular directory and then filtering out the files you don’t need. You can then add the sheet name using the formula tool and bring that into your batch macro.
I can look at your workflows on Monday and try to provide guidance but like I said that’s my process and it works pretty well.