delete row

[#1]

Hello,

i have a basic database qvd. can i merge this database qvd with an actual qvd with only actual changes and merge this two tables and remove the lines in the basic databse which are still existing in both tables and after that i want to concanate the lines from the actual qvd with the changes in the basic database.

I hope its clear what i need...

[richard_pearce6]

Yes you can, If you have an ID field which is unique (and therefore duplicated) you can remove it be using:

Where not exists([ID Field])

in the load statement.

Regards

Richard

QlikCentral.com

[jaimeaguilar]

Hi, search for 'Using QVDs for incremental Load' in QV help (F11), to see different scenarios,

regards