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

[vrbravo]

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

[chinu267]

This is a simple approach to get what you need.

[vrbravo]

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.

[chinu267]

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.