incremtal load

[#1]

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

[its_anandrjs]

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

[alexandros17]

Take a look in the help searching this string:

"QVD files and Incremental Load"

[Anonymous]

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;