Sort Render reports to Excel tabs

[Shohn]

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.

[apathetichell]

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

[Shohn]

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

[apathetichell]

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]

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]

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]

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 · Accepted solution]

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.  

[rlcmtch]

Thanks for the solution! Worked really well.

[KarolS]

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!!