Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jcampbell
Not applicable

Date Format & Load Solution

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);

Tags (4)