Alteryx designer Discussions

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

Sorting months as field names

Highlighted
Atom

Hi,

 

I now have my fields looking like this 

 

Capture.JPG

 

How do you sort field names? It seems that currently only althabetical order exists...

does anyone have a suggestion how to set months in proper order?

Highlighted

The easiest way is to use to convert the column names to yyyyMM format.

 

You can then sort these and finally use a dynamic rename to name them back in the original format.

Labels