Month format

[#1]

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.

[#2]

Hi Ariel,

i did try it, but it shows me numeric and string values together

[#3]

Hi,

It works fine, but month values are shown in random order. i gave definition : [MonthName(date)as Month]

but issue still persists.

[aveeeeeee7en]

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