Date Format & Load Solution

jcampbell — Fri, 03 Jun 2011 12:11:08 GMT

Thought I would share the following...I was importing data with field called "Date" with this format "MM/DD/YYYY" but I needed to break out each of those elements (Month, Day, Year) for analysis purposes. And with a very simple addition to my load script it works great:

MyData:

LOAD Date,

Year(date#([Date],'MM/DD/YYYY')) as Year,

Month(date#([Date],'MM/DD/YYYY')) as Month,

Day(date#([Date],'MM/DD/YYYY')) as Day,

Description,

Category,

Labels,

Notes

FROM

C:\somefile.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

topic Date Format & Load Solution in QlikView

Date Format & Load Solution