Order of columns after CrossTab

[BautistaC888]

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.

[gawa]

hi @BautistaC888 

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

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.

With my method, it preserves original name without underbar.

[Qiu]

@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.