community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Read in Multiple Excel Files, with Multiple Tabs that have Different Schemas

Meteor

Hi All,

 

I have the following scenario to read multiple excel tab from an excel sheet with different schema. ANy guidance would be greatly appreciated.

I understand that dynamic input is only for same schema but doesnt help in my case.

 

Thanks in advance.

 

Example 

 

abc.xlsx

 

tab1 - A, B, C, D,E,F,G 

tab2 - A,C,E

tab3 - A,B,C,D,E

 

I want to pull records from the three tabs and select  ONLY column A, C , E  ONLY.

 

Output:

Column A , Column C , COlumn E

 

 

Regards,

Vignesh

 

Highlighted
Meteor

 

 

This is a simple approach to get what you need.

Read in Multiple Excel Files, with Multiple Tabs that have Different Schemas.PNG

Meteor

Hello,

 

I dont want to go with the brute force method which is to use multiple input. It would be tedious if i have 1000 files and use 1000 inputs tool.

 

 

Meteor

Did a batch macro to read a directory of excel files with different columns/heders. Look at the workflow and if any confusion, plz ping me and I can explain. 

Labels