Automation batch files loop

[omkarshinde]

I have a excel file with first column as different locations, second column as different segments therefore I want Alteryx to take each row of this file to run my workflow and give me the unionised result of all files. Also this entire set should run for all months till the current calendar month.
Please guide me which exact tool/macro shall i go for to create this.

[FrederikE]

Hey @omkarshinde,

Your post is a bit unclear. Do you have one Excel file or multiple? Also, Alteryx always unionizes rows - that's a table. You might want to explain in more detail what you require. 

For unioning multiple Excel Files (and if required sheets aswell) see this article: 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Read-in-Multiple-Excel-File...

[omkarshinde]

please refer to this once
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macro-different-output-f...