In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Sort Render reports to Excel tabs

Shohn
7 - Meteor

If I had a rendered output to 3 excel tabs in one workbook. 2 tabs are employee detailed information and a summary tab of all employees. How would I put the Summary as Sheet1 and all employees after regardless of the tab/employees name? Lets use tabs labels "Adam" and "Tina" along with "Summary" How do I put Summary as the first tab.  NO workaround like "0_Summary", "1_employeeName" is ok or a solution to the question.

 

9 REPLIES 9
apathetichell
19 - Altair

I just commented on the other thread. basically just label your sheets with successive numbers - ie 1. summary...

Shohn
7 - Meteor

This is not helpful, which is why I posted it as a new question. This workaround is not acceptable.

apathetichell
19 - Altair

For the next would-be solver - here were my comments:

you send 3 fields into your layout.

1) table - a report snippet

2) sheet - your sheet names.

3) filename - your filename...

 

there are some ways to try to control sheet creation order - but tbh they call can have issues - so the bet way to control this is to label the sheets prior to the union (and prior to the layout). you would use sheet names like:

 

1. summary

2. employee detail

3. employee other detail

 

you then use these as the vertical section break in your layout tool. Excel will then show you 1 summary first.

Shohn
7 - Meteor

Still this is not helpful to my question and I had explained the what you are providing is NOT what I am after. I fully understand and can do what you are suggesting. The thing is the leadership that I am making this for, will not accept this. The reason being is I can do this whole thing in VBA and it will be perfect the way they want and push of a button So to put this on Alteryx Server and have it scheduled with Hands Off approach would mean I CANNOT have 1.Summary 2.Adam 3.Tina. which is they way they DON'T want it.

apathetichell
19 - Altair

Totally - there's probably someone with more experience here on this issue than me - and my post will help get them up to speed. Why not just run a VBA script post file creation to get this how you want it?

Shohn
7 - Meteor

It seems this maybe the only solution is to run a script to grab the file and move summary to the front. It wouldn't be bad for this situation. But if you had to move 2 or 3 tabs that are dynamic naming what a chore.

Shohn
7 - Meteor

This worked perfect. I can add any number of columns to Summary data and/or Employee data. You can change the sorting order asc/desc or the numbers themselves in the Tab Order Text Input.  

Shohn_0-1676380848325.png

 

rlcmtch
5 - Atom

Thanks for the solution! Worked really well.

KarolS
5 - Atom

Hooray - at last a simple solution - works like a charm.  Can also have the tab order within the data flowing through and just stick the sort in between the layout and the render.  THANKS!!

Labels
Top Solution Authors