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.

stevelord
Not applicable

incremental load of files

Hi, I have many folders with datafeed files accumulating on a daily basis and a qlikview of the contents of those files.  As the files become more numerous, the qlikview reload time increases.

Presently I have the qlikview process files dated more recently with:

Load.. From... Where NUM(<FileDateExpression>) >= NUM(Now()-2)

Then it loads the qvd of previously processed data with:

Load... From... Where NUM(<FileDateExpression>) < NUM(Now()-2)

This does a nice job of having it only do the processing work on newer files, and bring the previously processed stuff from older files out of the qvd that was made previously.  HOWEVER, the qlikview is still parsing through all of the files to check inside and see if any data to load.

Can someone provide me the script piece for qlikview to parse the file names themselves and not even look into the files when loading?  Would that save any more processing time in addition to time saved from not trying to process stuff in the files?

The filedate expression I have in the file loads is built on the filenames themselves, so would work to identify the files in such a script to tell it which ones to parse.

1 Reply
sergey_maka8
Not applicable

Re: incremental load of files

You can use variables as file names or part of file name.

Like

//load old data from qvd

[data]:

LOAD *

FROM olddata.qvd (qvd);

//load the new data

FOR i=0 to 2

Concatenate(data)

LET vDate=Date(Now()-$(i));

LOAD *

FROM

data$(vDate).xls

(biff, embedded labels, table is Sheet1$);

Next

STORE data to olddata.qvd;