topic Re: How to get month name from month number in Visualization and Usability

How to get month name from month number

aditya_pratap — Thu, 06 Oct 2022 16:19:10 GMT

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 — Thu, 06 Oct 2022 16:31:47 GMT

@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 — Thu, 06 Oct 2022 19:59:17 GMT

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

sidhiq91 — Fri, 07 Oct 2022 02:48:33 GMT

@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;