Multiple Tab input

[KANNAM2]

How To: Import multiple tabs from one Excel file which has different Schema. I found various solutions to input multiple tabs from multiple files with different Schema using a batch macro. In batch macro's i need to specify the sheet name, the reason i do not want to use batch macro as the file has 30+ tabs with different tab names and schema.

[MichalM]

@KANNAM2 

Do you want to import these into one big table or as 30 different streams?

[KANNAM2]

Yes, you are correct in one big table

[MichalM]

In which case the batch macro is the best way to achieve this. 

Use the Input Data tool to connect to your Excel workbook and read in the list of sheet names dynamically.

You can then feed these into a batch macro which will open each of these sheets and unions them together. See the option 3 in this blog post.

[KANNAM2]

Hi MichalM,

I tried the solution but still getting the below error. 

[MichalM · Accepted solution]

There's a problem with the configuration of your macro. 

The Input data tool within your macro needs to be configured to open one of the sheets within the file. And the data your passing into the macro through the control parameter (list of sheet names) will dynamically replace the reference to the sheet name.

[KANNAM2]

Thank you, this worked. Appreciate your help

[samraatg]

Can you provide some guidance to, how to input multi tabs to different work streams.

[DannyS]

@samraatg 

I would recommend checking out these two Community articles for different situations you might find yourself in for importing multiple tabs from Excel workbooks. See below:

• How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range 
• Read in Multiple Excel Files, with Multiple Tabs that have Different Schemas

[samraatg]

Thank you Danny. I will check out the links.