Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

How to change excel sheet order

Highlighted
8 - Asteroid

Hi Alteryx Team,

I am currently using the block until done tool to place my output excel in 3 different sheets..however the sheet order is off when running. How do I solve the order of the sheets to be according to my fancy?

Highlighted
Alteryx Certified Partner

Hey @stevegeorge 

 

I sometimes find adding additional tools to my workflow can better control the order in which the sheets get written....

 

Capture.PNG

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If you are using the Render tool to output formatted Excel sheets, then the sheet order will be alphabetic according to sheet name. I typically recommend adding a sheet number prefix if a specific order is desired. 

Highlighted
5 - Atom

I use a leading space to move " Summary" tab in front of the "Details" tab.  

Labels