Tutorials & Examples Web-help Blog

Sorting when pivoting



De action to pivot a dataset always sorts alphabetically. Is it possible to change this so that we keep de order in which the dataset was in de original long format ?



Yes, a separate table should be created with the correct order of columns and no data. Then the pivoted table is appended to it.

See the example below.
ordered-pivot.morph (3.1 KB)


Thanks for the reply. Could this feature be added to the pivot transformation .e.g. a checkbox that says “keep sorting order” so that we can simplify our flow?


Not at this point.