One xlsx workbook with multiple tabs and same schemas - how do I combine all tabs to one?

Question

Hello alteryx community,

Looking for help on this workflow.

We have 1 workbook with 16 tabs/worksheets. *sensitive data so I can't share but imagine

All worksheets/tabs have the same table format and column headers exist on row 8 of the worksheets.

The use case is to aggregate the data into one table for the workflow to prep and summarize.

How can I consolidate 16 tabs for 1 input?

Thank you!

acarter881 · Accepted Answer

Hey, @james_swanson. I answered this in a separate thread. See this post, specifically the one regarding the use of the Dynamic Input tool. Please let me know if this helps.