Extracting all tabs with one input tool

[rajputakansha]

Hi,

Not sure if this has been asked before. I want to extract data from all the tabs of one 1 excel file. My file has 12 tabs for each month and I want to import the file into alteryx using one input tool.

Can you suggest the most efficient way to doing this?

Thank you

[fmvizcaino]

Hi @rajputakansha ,

Take a look at the attached example where I'm using two dynamic inputs to read all the tabs from all files.

Best,

Fernando Vizcaino

[rajputakansha]

Hi @fmvizcaino ,

Thanks for sharing the workflow. What do I need to change in the workflow to make it work for my file? I changed the directory path and the sample file in Dynamic input.

Thanks

[fmvizcaino]

Hi @rajputakansha ,

I made it simple and for one file only now. You only need to change the input data file and the template as well.

The idea is to get all sheet names using an input data tool, for that, configure as image below.

Then, to dynamically insert the full path into other dynamic input tool to open them all.

Keep in mind that the dynamic input tool demands that all your tabs have the same structure.

Best,

Fernando V.