Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Extracting all tabs with one input tool

Highlighted
8 - Asteroid

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

 

Highlighted
Alteryx Certified Partner

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

8 - Asteroid

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

Highlighted
Alteryx Certified Partner

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.

fmvizcaino_0-1581719404658.png

 

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.

 

 

Labels