Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple Sorts into One Output File

crheintz
5 - Atom

I have a Excel file I want to sort via multiple factors. I was wondering is there a way to take the multiple sorts and make it into one output excel file  where each sort is a new sheet. 

Simplified example attached. 

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora

Hi @crheintz ,

 

I would use Block Until Done tool to avoid error in writing to the second sheet.

The attached workflow assumes the output file does not exist before running.

If it exists, you need to change the option in Output Data tool.

 

Yoshiro_Fujimori_0-1684620512053.png

I hope this helps. Good luck.

crheintz
5 - Atom

Thanks, This works perfectly. 

geraldo
13 - Pulsar

@crheintz 

your need may also have this resolution

 

geraldo_0-1684637171696.png

 

 

Labels