Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
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