Table/ Render Tool Changing Output Sort Order

[KerryW]

I have a sorted dataset that I want to render to Excel, grouping the items by a tile group number.

The rows are correctly sorted leaving the Sort Tool (1,2,3,4,5, etc), however, coming out of the table tool, the sort is (1,2,13, 3, 4,5, etc)
I have run the workflow with or without AMP, changed the values from String to V_string to V_W_String, and continue to receive the same results

I have attached the workflow and output generated from the temp Excel output

Any insight into how or why the sort would change would be greatly appreciated!

[DataNath]

Hey @KerryW, what version of Alteryx are you using? I'm on 2022.3 and get the same issue as you when AMP is enabled. However, when I disable AMP, the result sorts as expected:

With:

Without:

[CharlieS]

Rendering named sheets to Excel will follow string sort order so you'll likely have to pad your numbers with leading 0's so that the string sorts correctly. A Multi Field Formula could change the Tile_Num field to a string and allow the use of PadLeft(ToString([Tile_Num]),2,'0'). 

[Pang_Hee_Choy · Accepted solution]

Actually, you can sort after the table tool...

for me it work well.

[KerryW]

Perfect and simple

I didn't realize a sort could be used after a table!

Many Thanks