Reading data from multiple tabs in an excel input file

[Idyllic_Data_Geek]

I have a requirement in which I want to bring in the data from 4-5 different tabs in an excel file before performing any scrubbing. The header names are same in all the tabs. How can I accomplish this instead of bringing in input tool for each tab?

[Idyllic_Data_Geek]

Thank you. Is there any existing solution that I can look into and configure/create macro accordingly?

[prashant007]

You can  use batch macro to achieve this

[ddiesel]

@Idyllic_Data_Geek 

You can try the "Directory.yxzp" workflow referenced in this post by @LordNeilLord:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-worksheet-names-from-excel/td-p/34...

The workflow consists of two batch batch macros. The first macro extracts the sheet names. The second macro inputs the files. 

Give it a try and let us know how it goes!

Thanks,
Deb

[Jay-RDC]

Hey man. Just checking if you your issue has been resolved.