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!

DataNath

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.