SOLVED
Divide an Excel file into multiple workbooks and sheets.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JennyRuns24
8 - Asteroid
‎04-10-2023
03:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have an excel spreadsheet with a list of properties. In Alteryx, I'm attempting to create a new workbook for each unique property and a new sheet within that workbook for each Space ID. For example, in this screenshot, I want Alteryx to generate two Excel workbooks (ABC and DEF), with eight different sheets for each space ID in Workbook ABC and three sheets for the three space IDs in Workbook DEF. Excel sheet is attached. Can someone please help? Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Parse
2 REPLIES 2
nagakavyasri
12 - Quasar
‎04-10-2023
04:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@JennyRuns24 try this
‎04-11-2023
06:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much for your assistance! I'm wondering if there's a way to have the output generated in each sheet go from top to bottom rather than left to right?
