Table/ Render Tool Changing Output Sort Order

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!

2023-04-04 16_36_15-Alteryx Designer x64 - Render Tool Sort Issue.yxmd.png

2023-04-04 16_37_58-Alteryx Designer x64 - Render Tool Sort Issue.yxmd_.png

Render Tool Sort Issue.yxmd

Output.xlsx

Datasets

Data Investigation

Accepted answers

AncientPandaman

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

for me it work well.

All comments

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').

AncientPandaman

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703