Alteryx Designer Discussions

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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

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

7 - 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
8 - Asteroid

 

 

This is a simple approach to get what you need.

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

Highlighted
7 - 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.

 

 

Highlighted
8 - Asteroid

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