Tutorials & Examples Web-help Blog

Sorting when pivoting


#1

Hi,

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 ?

Thanks,
Nikolaas


#2

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)


#3

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?


#4

Not at this point.