Need to pull data from multiple tabs of excel workbook with source tabs names

[hbakshi]

Hi,

I am pretty new on Alteryx and need help in pulling data from specific tabs of an excel workbook which has more than 20 tabs. Additionally, I need to have a column having values as the name of source tab the data has been pulled from. Can somebody help? Thanks in advance.

[atcodedog05]

Hi @hbakshi 

Refer this article it might help

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

The approach is definitely to use Directory tool and maybe filter sheets and then dynamic input tool.

Hope this helps🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[mceleavey]

Hi @hbakshi ,

you can do the standard method as pointed out by @atcodedog05 , but that often causes problems with the template not fitting the schema on all sheets.

I've attached two macros that allow you to first retrieve all sheet names, which you can then append to the fullpath, then feed that into the second macro which will load them all in for you.

I've built the example and attached the macros.

Hope this helps.

M.