Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to sort by month, not alphabetical

Lauriek
7 - Meteor

Can someone help with the below grid to be sorted by month order, not alphabetical.

 

April59362695.77
August88065329.94
December86659085.87
February27117735.67
January59912193.9
July79757626.22
June70884268.54
March45235901.16
May89641660.98
November95846400.13
October83070284.84
September75695732.11

 

I saw some past posts about it, but still cannot get it to work.

4 REPLIES 4
JaeLim
Alteryx
Alteryx

Hi @Lauriek,

Please refer my solution below, I first convert the month names into date data type, and sort them in numeric format. 

JaeLim_0-1644529963028.png

 

Hope this helps!

 

Qiu
20 - Arcturus
20 - Arcturus

@Lauriek 
If only for Months, we may create a lookup take in this way, the calculation load will be less if the data is huge.

0211-Lauriek-A.PNG0211-Lauriek-B.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @Lauriek 

 

Here is my take

 

atcodedog05_0-1644560683372.png

 

Hope this helps : )

 

Lauriek
7 - Meteor

That worked!  Thank you for the help.

Labels