Reading data from multiple tabs in an excel input file

[Idyllic_Data_Geek]

I have a requirement in which I want to bring in the data from 4-5 different tabs in an excel file before performing any scrubbing. The header names are same in all the tabs. How can I accomplish this instead of bringing in input tool for each tab?

[taylor_made]

Hello, 

The top part of this article should explain how you can import multiple tabs with the same schema at once using the dynamic input tool: 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets... 

[Idyllic_Data_Geek]

Will this work if I need to bring in the selective sheets?

[AmalinaH]

You can add in a filter tool if you want to add a condition on which sheets to bring in. So it would look something like this:

Attached sample excel data source and workflow.

[Idyllic_Data_Geek]

I'm not able to figure out this step in the dynamic input tool. How do I make dynamic input tool read from the input tool?

[AmalinaH]

The input tool is configured to only import the list of sheet names from your Excel workbook:

So the result would look something like this:

The dynamic input tool would import based on the Field "Sheet Names" which is your list of all the sheets that you got from the first tool. The action to "Change File/Table Name" basically means that the dynamic input does a "batch" processing input of every sheet name in the list and unions the results together to provide a single combined dataset of all the sheets.

Not sure if I fully answered your question but let me know if I can be clearer :)

[Idyllic_Data_Geek]

my question was on the below highlighted, How do I connect to the same file in dynamic input tool that I connected to in step 1 using input tool

@AmalinaH @taylor_made 

[AmalinaH]

Hi @Idyllic_Data_Geek, I'm not sure if there is a simple solution for that (unless I'm missing something!). Is there a reason you can't select same file again? It's more just for the purposes of providing a template of the file rather than taking the data itself, as this would be based off the sheets that are specified.

[Idyllic_Data_Geek]

It does not work. It is giving me an error for dynamic input schema. Even though the schema name is same

[AmalinaH]

Are you able to show us a screenshot of your Data Input configuration as well as the Dynamic Input configuration?