For an update you will need to have a modification time. Meaning with the first QVD load you check the modification time like: WHERE ModificationTime >=#$(LastExecTime)#;
Then you perform a Concatenate with the new data with a where NOT clause like:WHERE NOT Exists(PrimaryKey);
Hope this helps!
Hello Rob and Gert
I think I'm not being correct in my words... Sorry...
My intention is update only two columns of the same line.
I tested the solutions that are being presented but they return only the new records.
I don't change my primary keys because it's not a new record that i'm trying to insert. I'm trying to update the information of the column with a defined primary key...
Is this even possible?!
Thanks for your help.