Import Multiple Worksheets with Same Schema
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Batch Macro
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ridodson the below post might be helpful for your use case
Solved: Get worksheet names from excel - Alteryx Community
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Once I am able to pull the sheet names, how do I run through the "Sunday" tabs and consolidate them in to one output?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator