Multiples tab within the same excel file

Hussein982

Hi All: I have one excel file with 4 or 5 tabs. All tabs are the same structure/schema. How can I bring all of them into one tab in Alteryx taking into consideration that the header of each tab is the same as the other tab.

Could you please attach a workflow as part of your response.

thanks in advance.

martinding

Hi @Hussein982 ,

Since the schemas are the same, a common approach is to make use of the dynamic input tool.

So in the first step, you import the list of sheet names, and in the 2nd step, you use the dynamic input tool to replace the sheet name based on the list of sheet names from the 1st step.

The results are automatically unionised together.

Example Workflow - multiple tabs.yxzp