topic Re: incremtal load in QlikView

incremtal load

Wed, 18 Jun 2014 14:01:13 GMT

Hi,

how can i overwrite existing rows in a qvd ?

with concatenate i put the non existing rows to the qvd, but if their is a existing primary key row and onlay the values are cahnged how can i make an upload of this changes in a actual qvd?

Thanks

Re: incremtal load

its_anandrjs — Wed, 18 Jun 2014 14:06:33 GMT

Use primary keys and then use key word Where exists and replace by concatenate the table. If having any data then provide please.

Re: incremtal load

alexandros17 — Wed, 18 Jun 2014 14:07:05 GMT

Take a look in the help searching this string:

"QVD files and Incremental Load"

Re: incremtal load

Anonymous — Wed, 18 Jun 2014 14:29:17 GMT

Hi,

Assuming Temp1.Qvd is all the already existing data

vlastExectime =reloadtime();

Temp:

Load Key, X, Y FROM TABLE1

WHERE ModificationTime >= $(vlastExectime);

Concatenate LOAD PrimaryKey, X, Y FROM Temp1.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO Temp1.QVD;