Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Divide an Excel file into multiple workbooks and sheets.

JennyRuns24
8 - Asteroid

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!

 

JennyRuns24_0-1681164059424.png

 

2 REPLIES 2
nagakavyasri
12 - Quasar

@JennyRuns24  try this

Excel to multiple.png

JennyRuns24
8 - Asteroid

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?

Labels
Top Solution Authors