Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to do incremental load using primary key


Hi Friends,

I dont have a date column but have a primary key.

Please explain how to do incremental load using primary key.

Thanks

Pavan

4 Replies
Anonymous
Not applicable
Author

Hi,

First load your last qvd created, and then load the new data from your source.

load fields...

from yoursource

where not(exists(keyfield));

so this will load only the data of your new keys.

Finally, store your table for next incremental load.

Marc.

tabletuner
Creator III
Creator III

use the exists() function in your where clause. look it up into the manual. that will do.

Regards,

Tjeerd

its_anandrjs

Use Max function for this in the load script

Load

ID // Which is primary key

From Location Where ID > Max(ID);

Note:- But need to check how you need incremental load with ( Insert,Update,Delete ) or otherwise it is allready maintain in database.

Regards,

Anand

maxgro
MVP
MVP

search using qvd files for incremental load in online help, case 3

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

//WHERE ModificationTime >= #$(LastExecTime)#

;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO File.QVD;