topic Re: Incremental Load in QlikView

Incremental Load

prma7799 — Fri, 17 Nov 2017 06:50:23 GMT

Hi All,

I have one table called "GL Entry " i wanted to apply incremental logic on it and EntryNo has unique key.

Can anyone explain me how to apply incremental logic for Insert and update .

Thanks

shraddha_g — Fri, 17 Nov 2017 07:03:42 GMT

if you have stored one time data into qvd then you can get Max(EntryNo) from that Qvd

MaxDate:

Load

Max(EntryNo) as LastUpdatedEntry

from......PreviouslyLoaded.qvd

(qvd);

Let vEntry = num(num#(peek('LastUpdatedEntry')));

OracleNewData:

Sql Select *

From ..Source

Where EntryNo > $(vEntry) ; // Here EntryNo format should match with the one with the Oracle EntryNo field

prma7799 — Fri, 17 Nov 2017 07:06:24 GMT

I thing this logic useful for only insert how to apply logic for UPDATE

shraddha_g — Fri, 17 Nov 2017 07:09:25 GMT

MaxDate:

Load

Max(EntryNo) as LastUpdatedEntry

from......PreviouslyLoaded.qvd

(qvd);

Let vEntry = num(num#(peek('LastUpdatedEntry')));

OracleNewData:

Sql Select *

From ..Source

Where EntryNo > $(vEntry) ;

Concatenate

Load *

From PreviouslyLoaded.qvd

Where not exists(EntryNo,EntryNo)

;

Store OracleNewData into PreviouslyLoadedQvd;