Problem with months

[#1]

Hey, i have the following problem

I have a field month in QV like 1.2.3.4.5...

I want them appearing like "Jan, Feb, Mar".. but in order.

I mean, i put something like this:

If month=1, Jan, If month=2, Feb....

But dont know how to order them... because when i select anything else, they get mixed. "Mar,Feb,Jun,Apr"

Any solution??

Thanks

[MayilVahanan]

Hi

Try with Mapping and ApplyMap concept to achieve this

Like

MapTable:

Mapping Load * inline

[

Month, MonthName

1,Jan

2,Feb

..

!2,Dec

];

Load ApplyMap('MapTable',Month) as Month, * from tablename;

Hope it helps

[Brice-SACCUCCI]

Hi,

here is a way to get the correct month value, which will have the right sorting order.

MonthNum:

LOAD * INLINE

[

monthNum

1

2

3];

LOAD

    monthNum,

    month(MakeDate(2013, monthNum)) as Month

RESIDENT

    MonthNum;