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?
Solved! Go to Solution.
Hey @henrygeorge
I sometimes find adding additional tools to my workflow can better control the order in which the sheets get written....
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.
I use a leading space to move " Summary" tab in front of the "Details" tab.
Hi @CharlieS ,
Is this still the only solution to change orders of sheets in the render tool? by using a prefix?
Thanks!
@IvanFonseca wrote:Hi @CharlieS ,
Is this still the only solution to change orders of sheets in the render tool? by using a prefix?
Thanks!
Yes. The rendered sheets will be string-sorted. I typically just number my sheets in the order I want.