We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reporting tool customize the sheet order

vijaylnyadav
8 - Asteroid

Hi,

 

I am using layout and render tool in my workflow and the output i am getting is the at the order of the sheets is in alphabetical order so can we customize the order of sheets.

 

vijaylnyadav_0-1612764283476.png

 

vijaylnyadav_1-1612764308015.png

 

can we get any solution for this.

11 REPLIES 11
Qiu
21 - Polaris
21 - Polaris

@vijaylnyadav 

So what kind of order you want? 😁

vijaylnyadav
8 - Asteroid

Hi @Qiu

 

i want a particular sheet on the first sheet say for eg. sheet name "zebra" i want this sheet name on the first sheet.

Qiu
21 - Polaris
21 - Polaris

@vijaylnyadav 
Do you accept something like "0-Zebra"?😁

vijaylnyadav
8 - Asteroid

Hi @Qiu ,

 

Thanks for the suggestion but i want the exact name "Zebra" on the first tab on the output excel file because it is the requirement.

Qiu
21 - Polaris
21 - Polaris

@vijaylnyadav 

So I understand your requirement, but I am sorry I dont know how to do it.

If you are accepting plain Excel via Output Tool, I think we can do it, but not the Render tool.

Qiu_0-1612766942097.png

 

vijaylnyadav
8 - Asteroid

@Qiu we are getting all the sheets in the same output excel file?

can you please attach the workflow? so that i can refer?

Qiu
21 - Polaris
21 - Polaris

@vijaylnyadav 
See attached. The order is as you requested.

0208- vijaylnyadav.PNG

vijaylnyadav
8 - Asteroid

@Qiu I am using reporting tool because I want to highlight some of the columns thats why.

 

But as per the workflow it is using output tool.

 

Is it possible to use with render tool or any of the reporting tool.

Qiu
21 - Polaris
21 - Polaris

@vijaylnyadav 
Not to my knowledge...😑

Labels
Top Solution Authors