Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Table/ Render Tool Changing Output Sort Order

KerryW
7 - Meteor

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!

 

 

 

 

4 REPLIES 4
DataNath
17 - Castor
17 - Castor

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:

 

DataNath_0-1680641800927.png

DataNath_1-1680641812171.png

 

Without:

 

DataNath_2-1680641837397.png

DataNath_3-1680641844361.png

CharlieS
17 - Castor
17 - Castor

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

PangHC
12 - Quasar

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

for me it work well.

Pang_Hee_Choy_0-1680657640321.png

Pang_Hee_Choy_1-1680657655493.png

 

 

 

KerryW
7 - Meteor

Perfect and simple

 

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

 

Many Thanks

 

Labels
Top Solution Authors