topic how to do incremental load using primary key in QlikView

how to do incremental load using primary key

Mon, 20 Oct 2014 09:11:01 GMT

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

Anonymous — Mon, 20 Oct 2014 09:13:57 GMT

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 — Mon, 20 Oct 2014 09:14:36 GMT

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

Regards,

Tjeerd

its_anandrjs — Mon, 20 Oct 2014 09:15:44 GMT

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 — Mon, 20 Oct 2014 09:18:40 GMT

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;