Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

How to arrange Created Excel files in Different order not Alphabetic?

Highlighted
8 - Asteroid

Hello all,

I'm creating excel file with multiple sheets.The order is Alphabetic how can i change the order in my way Without adding numbers infront or sth like this.

 

Using:Table tool Then Formula (to set the sheet name) THEN a Union (with the order that i want to ) THEN Layput THEN Render.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I'm not aware of a way to render sheets to Excel that are not in alphabetic order. That being said, It may be possible to reorder the sheets after the fact with some VBS via Run Command. 

Highlighted
17 - Castor
17 - Castor

Hi @MostafaBouzari 

 

Is it essential that you go through the reporting tools?  If not, you can output in any order using an output batch macro like the attached.  The batch runs once for each sheet and creates them in the order defined by the order column.  The resulting Excel file has the sheets in the custom order

 

r.png

 

Dan

 

 

 

 

 

Labels