Import Multiple Worksheets with Same Schema

[ridodson]

Hello Alteryx Community,

I am attempting to import in multiple Excel workbooks in to one workflow through a batch macro. In this example, all daily worksheets (named: Sunday, Monday, etc.) throughout all workbooks in a directory have the same schema. Attempting to:

• Pull in and consolidate each daily view (read: all Sunday tabs are consolidated in to Sunday data stream, Monday tabs are consolidated in to Monday output)
• Join all consolidations in to one output data stream that captures each day on its own worksheet

Any help would be greatly appreciated!

[binuacs]

@ridodson the below post might be helpful for your use case

Solved: Get worksheet names from excel - Alteryx Community

[ridodson]

Once I am able to pull the sheet names, how do I run through the "Sunday" tabs and consolidate them in to one output?

[DataNath · Accepted solution]

In your interface designer properties tab, set your union to be by name (or position is fine if the schema is the same). If this brings in all days of the week together then you can just add a select tool to remove days of the week you don't want for that stream. If your weekdays are within the rows themselves then you can of course use a filter too.

[ridodson]

Thank you, @DataNath @binuacs for the solutions. Was able to figure the issue out by writing all of the individual workflows through to the same Output Data tool, and then changing the sheet names to reflect how I wanted the reports to be sorted.