cross tab tool keep original column order

[187]

Hi Atleryx engineer,

I used cross tab tool to do the pivot staff, but the transposed column will in alphabetic order, which is not consistent with what I expected. Is there any way it can keep the same order like row number?

[binuacs]

@187 Can you provide sample data

[IraWatt]

Hey @187,

Here is an example setup to keep the ordering after a cross tab. It will work with all column headers except those with "_" in them.

If your headers contain "_" there are a few adjustments to make.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[grazitti_sapna]

@187, you may use the tile tool in that case in order to main the column order.

Thanks!

[grazitti_sapna · Accepted solution]

@187, sharing one of the examples that might help you to understand.

Thanks!

[187]

this is awesome!! thanks a lot

[3I_ATLAS]

Ingenious efficient solution, thank you!  the Cross tab tool itself should give us the option to preserve the field order according to how they come up in the records.  Hopefully in a future release.