Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
The data for field "month" is in number format, how can i change it as Jan,Feb,Mar,Apr,May...Dec?
Thanks
month(MakeDate(2000,yourfield,1)) as MonthName
Can you provide the script?
Pick(Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')
OR
Use SET Environment of
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
Instead of
SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12';
OR Final table seems This.
LOAD Pick(Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') as Month;
Load * Inline [
Month
1
2
3
4
5
6
7
8
9
10
11
12
];
Month(Date#(Month,'M'))
hope this helps
regards
Marco