Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Month(Date#(month_no,'M'))
@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;
Month(Date#(month_no,'M'))
@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;