topic Re: incremental Load in QlikView

incremental Load

Nagaraju_KCS — Mon, 24 Jun 2013 04:57:02 GMT

Hi All,

1. Store the previous load as a QVD

2. Load the previous load as a QVD files.

3. get maximum date from previous QVD file

4. :Load the new data where data is greaterthan maximum date from previous QVD file.

this is the process of incremental load....................

but i don't have date field in my tables....

then how to implement......

Thanks in Advance................

Re: incremental Load

Mon, 24 Jun 2013 05:19:04 GMT

see link

http://www.learnqlickview.com/incremental-data-load-in-qlikview/

Re: incremental Load

Mon, 24 Jun 2013 05:23:23 GMT

Use this script

LET lastReloadTime = ReloadTime();

GA_DATA:

LOAD

PK,

Calendardate,

Revenue

FROM (qvd);

CONCATENATE

LOAD

PK,

Calendardate,

Revenue

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE (Calendardate > $(lastReloadTime));

store GA_DATA into ;

Re: incremental Load

er_mohit — Mon, 24 Jun 2013 05:25:10 GMT

Go to this link

hope it helps you

http://www.quickintelligence.co.uk/qlikview-incremental-load/