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

Alteryx designer Discussions

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

The latest release includes several enhancements designed to improve your Community experience!

Learn More

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

Highlighted
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

 

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