Converting numbers to month

[Anonymous]

Hi all i have month i have month field it was shows numbers like

Month

1

2

3

4

5

6

7

8

9

10

11

12

it numbers convert to January,February,march.....

pls help me thanks in advance.

[tresesco]

Try like:

Load

          Month(MakeDate(1,Month)) as Month

[Anonymous]

not working bro

[tresesco]

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Load

         Month as MonthNum,

        Month(MakeDate(1,Month)) as Month

;

Load * Inline [

Month

1

2

3

4

5

6

7

8

9

10

11

12];

[Anonymous]

LOAD

* INLINE [

    Month

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    11

    12

];

load Month(MakeDate(1,Month))as month

[Anonymous]

its working

Thanks bro