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 · Accepted solution]

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.

[Hussein982]

@martinding well received and thank you!