Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help!
I want to load a date field which is in the excel file as "period" in the following concatenated format YYYYMM eg. 201306
I've split this into Month and Year as follows:
LOAD
left(PERIOD, 4) AS "Year",
right(PERIOD, 2) AS "Month",
How do I convert the numeric month into a text month within the load statement
does a switch case type statement work or is there a function to convert this?
Please give examples!
Maybe try something like:
Year(Date#(PERIOD, 'YYYYMM')) as "Year"
e.g. for 201306 will return "2013"
Month(Date#(PERIOD, 'YYYYMM')) as "Month"
e.g. for 201306 will return "Jun"
Maybe try something like:
Year(Date#(PERIOD, 'YYYYMM')) as "Year"
e.g. for 201306 will return "2013"
Month(Date#(PERIOD, 'YYYYMM')) as "Month"
e.g. for 201306 will return "Jun"
Excellent, that worked perfectly. My thoughts were heading in the right direction but weren't concluding in anything as efficient as this.
Thanks alot for your help!