Combine select set of Excel tabs from one file into one input tool

kheuer

Hello,

I have an Excel file with 20 worksheet tabs. 17 of them have the same data schema, 3 of them are completely different. I would like to combine the 17 worksheet tabs into one data input. I played around with the Dynamic input tool but could not configure it to ignore the 3 worksheet tabs that are different. What is the best way of accomplishing this task?

Thanks much,

Kristina

Claje

So one of the Table Options on the Input Data tool is "List of Sheet Names".

You should be able to do a flow something like this screenshot:

Let me know if this makes sense, or if you're still missing information you need to accomplish this.