Sort Columns of Cross Tab Output

Maybe I missed this in the configuration somewhere, but is there a way to sort the column headers (alphabetically) resulting from the Cross Tab tool?

Upstream of the Cross Tab, I tried sorting the rows that would become the Cross Tab column headers (ie: Item Type), but this didn't help.

Thanks!

Cross Tab Config.jpg

Developer Tools

Accepted answers

alexnajm

The Cross-Tab tool will automatically reorder columns in alphabetical order!

All comments

MilindG

@jdallen75 Perhaps you can use Select tool to reorder your columns?

jdallen75

I thought of that, but the list of columns is not available at design time - only dynamically at run-time due to how the Cross Tab functions.

alexnajm

The Cross-Tab tool will automatically reorder columns in alphabetical order!

AncientPandaman

@jdallen75
you can create an order column and add them to the font of column name.

then use rename tool to remove the prefix name.

Screenshot 2023-08-02 101305.png

Screenshot 2023-08-02 101317.png

Screenshot 2023-08-02 101325.png

Just so so ! 👍

i just have a similar situation. can you try on the workflow i attached?

@jdallen75can you try the sort for only item type? it works for me.

Screenshot 2023-08-08 103751.png

Example.yxmd

flying008

Hi, @PangHC

What are you want output ? The random input only get random output , cross-tab tool can't order it.

AncientPandaman

@flying008 it an example that crosstab is not automatically reorder columns in alphabetical order.

I wonder why this happen

beside, it still not sort accordingly even i turn off AMP.

flying008

Hi, @PangHC

1- In fact , the Cross-Tab tool will automatically reorder columns in alphabetical order, whatever use AMP.

2- In your case, because the 'Random % Sample' macro use a rand() function to process data, then output uncertain result at each run. unless you use a fix tool to sort it .

3- I repeat your work in v2021.2.x, get same result like disarray fields between output-1 and output-2. so maybe this is a bug of version?

录制_2023_08_08_14_02_13_842.gif

AncientPandaman

@flying008 ya, it become one more thing to be aware in future development.

further explain on the AMP (your question 1), when i turn on AMP, it works fine for output 2, but if i turn off AMP, output 1 and 2 are disarray...

in further testing, if I duplicate result in transpose (copy and paste in text input and start run from here), the result is fine...

don't know what to do to avoid this...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703