Arranging Months

[rathnam_qv]

Hi all,

i have months from Jan,Feb....Dec.

but i want to display from Nov,Dec,Jan,Feb....Sep,Oct

is it possible if so,please help me

Thanks in advance!!!

Smiley

[ariel_klien]

Hi,

you can write in your script an inline table like this:

LOAD * INLINE [

    Month, month_num

    Nov, 1

    Dec, 2

    Jan, 3

    Feb, 4

    Mar, 5

    Apr, 6

    May, 7

    Jun, 8

    Jul, 9

    Aug, 10

    Sep, 11

    Oct, 12

];

and then sort it by month_num

BR

Ariel

[fernando_tonial]

Hi,

You can try this:

Map_Month
Mapping
LOAD * INLINE [
    Month, month_num
    Nov, 1
    Dec, 2
    Jan, 3
    Feb, 4
    Mar, 5
    Apr, 6
    May, 7
    Jun, 8
    Jul, 9
    Aug, 10
    Sep, 11
    Oct, 12
];

Data:
Load 
Dual(Month, ApplyMap('Map_Month',Month) as Month
From Table;

This form will be ordering as you set the mapping table.

Best Regards.

Tonial.

[jagan]

Hi Rathnam,

Arrive month field in the script like this

Load

*,

Dual(MonthNameDimension, Match(MonthNameDimension, 'Nov', 'Dec', 'Jan', ............'Oct')) AS Month

FROM DataSource;

Hope this helps you.

Regards,

Jagan.