Alteryx Designer Desktop Discussions

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

Order of columns after CrossTab

BautistaC888
8 - Asteroid

Hello,

I need to keep a certain order of the columns after a CrossTab (Given by the column order).

The columns are dynamic, so i can't use the select tool.

I would like to know if there is way to order the columns after the cross tab.

Thank you.

2 REPLIES 2
gawa
15 - Aurora
15 - Aurora

hi @BautistaC888 

 

Please see the attached WF to maintain the specific order of columns.

image.png

Another advantage by this method is that you can maintain the original column name as it is.

In Cross-tab tool, they replace any special characters(except for underbar _ ) to underbar "_".

With your WF, column name becomes PARA_IMPUTAR, including underbar.

image.png

With my method, it preserves original name without underbar.

image.png

Qiu
21 - Polaris
21 - Polaris

@BautistaC888 
I uasually will create the new column names with the order number as prefix, but it does have the issue of "Underbar".

but we can deal with it with Dynamic Rename Tool if the naming is not so complex.

0124-BautistaC888.png0124-BautistaC888-A.png

Labels