Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two tables with Month column, in table 1, it shows month as 1, 2, 3, 4, ... 12 which i renamed using load* inline as jan feb...
but in table 2 , i have month column which has values like Jan, February, Mar, Apr, May, June... . how can i change the month format for this table2? so that month column has similar values which can later be easily joined.
Hi Ariel,
i did try it, but it shows me numeric and string values together
Hi,
It works fine, but month values are shown in random order. i gave definition : [MonthName(date)as Month]
but issue still persists.
Hi
If you have Month & Year than Use this Expression:
dual(left(monthname(makedate(YEAR,MONTH)),3),MONTH) AS MONTH_NEW
Example:
Load *, dual(left(monthname(makedate(YEAR,MONTH)),3),MONTH) AS MONTH_NEW Inline [
MONTH, YEAR
1, 2014
2, 2014
3, 2014
4, 2014
5, 2014
6, 2014
7, 2014
8, 2014
9, 2014
10, 2014
11, 2014
12, 2014
];
Also, see the Attachment.
Regards
Aviral Nag