Simple Batch Macro to Read Multiple identical schema tabs from a single excel file

[Carluccio555]

Can someone please help with a simple refresher on batch macros? I've been googling but everything I find is more complicated than I'm trying to achieve.

I have an excel file with the Tabs: NA, EUR, APAC, LATAM with identically structured schemas. Rather than setting up 4 Input Data tools I want to use a batch macro to bring in all the tabs (I will then add a union to them).

The list of tab names I've created from a Data Input (Sheet names only) and Sample Tool to isolate only the 4 tab names needed, where do I go from here?

Thanks

[ChrisTX]

Your Input Data tool can bring in the List of Sheet Names, then Filter the sheet names (if needed), then use a Dynamic Input tool.

Check out this post:  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-input-Directory-and-Dynamic-inpu...

Chris