Batch macros with Excel tabs

jgiacomazzi

My use of batch macros in Alteryx is limited. I know that a batch macro runs one time for each record in an input file and that an output is generated each time, and a union of the outputs is created. I am wondering if it's possible to create a batch macro that runs one time for each Excel tab in an input file. If so, how can I do this?

Luke_C

Hi @jgiacomazzi 

This is definitely possible, here are some links:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-Multiple-Excel-sheets-with-a-Dynamic-Input-tool/ta-p/1243

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have/ta-p/51145/jump-to/first-unread-message

Typically you'll input the file and choose 'list of sheet names' and also opt to include the full path as the field. You can then update the full path to use the various tab names and pass those through to the batch macro. One key thing is knowing whether or not each tab has the same schema, which would impact your approach.