How to get month name from month number

[aditya_pratap]

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

Good Evening

i am using month_no column in my app but i want month_name with the help of month_no column how we can use.
kindly help me in this.

Thanks
Aditya

[sidhiq91]

@aditya_pratap  Could you please try something like below in your script:

Temp:
Mapping Load * inline [
Month, MonthName
1,Jan
2,Feb
3,Mar
4,Apr
5,May
6,Jun
7,July
8,Aug
9,Sept
10,Oct
11,Nov
12,Dec
];

NoConcatenate
Temp:
Load Month,
ApplyMap('Temp',Month) as MonthNames
inline [
Month
1
2
3
4
5
6
7
8
9
10
11
12
];

Exit Script;

[MarcoWedel · Accepted solution]

Month(Date#(month_no,'M'))

[sidhiq91]

@MarcoWedel  I tried your solution and it worked perfectly fine. Thanks.

NoConcatenate
Temp:
Load Month,
MOnth(Date#(Month,'M')) as Month_Name

inline [
Month
1
2
3
4
5
6
7
8
9
10
11
12
];

Exit Script;