Month Sorting

[aditya_pratap]

Hi Everyone,@Michael_Tarallo @mbj @petter @richbyard @Mp3Leaks @rohitk1609 @Marcus_Spitzmiller @ergustafsson @Masaki_Hamano @Sue_Macaluso 

Good Evening

In this app i am using month column and i have months from feb to sep but i am not getting in sort order like feb, march, april, may , june but i am getting in different order as u can see in picture .Kindly help me in this.

Thanks 
Aditya

[Mark_Little]

HI @aditya_pratap 

Check the Sorting on the column. Depending on you data it may be as simple and tick sort numerically.

[aditya_pratap]

Hi Not coming I tried that u have said to me 

Thanks 

Aditya

[RsQK]

Hi, there are various ways how to do this, one quite simple would be to make this "textual" field as a "dual" field. The script would be something along the lines of this:

ml_month_sort:
MAPPING LOAD
Month,
ROWNO()
INLINE [
Month
January
February
March
April
May
June
July
August
September
October
November
December
];

data:
LOAD *,
DUAL(Month,APPLYMAP('ml_month_sort',Month))	as MonthSorted;

LOAD 
TEXT(Month)	as Month
INLINE [
Month
April
August
December
February
January
July
June
March
May
September
October
November
];

and in the frontend with auto sorting settings: