Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Input Multiple Excel tabs at once

sagarpatel11
5 - Atom

I am trying to use this one excel that has over 100 different tabs. I want to take specific information from each tabs and create an excel but I don't want to create 100 inputs. Is there a way to bring all tabs in one put and then tell it to take specific information from each tab and create an output. All the tabs are formatted similarly.

 

Thanks.

2 REPLIES 2
ckorte
6 - Meteoroid

This prior thread about using the "Dynamic Input" tool should answer your question....

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Input-multiple-Excel-sheets-or-tabs-at-once/...

 

NirajSingh
5 - Atom

Hi Sagar,
Please use input Tool and Dynamic Input Tool as well.

First Configure Input Tool with the file and import only list names in Input Tool then connect input tool with Dynamic Tool and configure it too.

Please find the below images for configuration. Hope it'll work.

 

Configure Input Tool as below Img1:

NirajSingh_1-1667825683124.png

 

Img 2:

NirajSingh_0-1667825417347.png

 

Configure Dynamic Input Tool Img3:

 

NirajSingh_2-1667825769840.png

 

Image4:

NirajSingh_3-1667825864802.png

 

Image5:

NirajSingh_4-1667825941511.png

 

 

Labels