3 Replies Latest reply: Oct 7, 2015 8:07 AM by Anuj Koshti RSS

    Update/Delete/Overwrite (not insert) single records in QVD file?

    Simon Hogg

      I have a large list of customer records and of course, from time to time those records changed (addresses are changed, marketing segmentations are updated, etc).

       

      I can extract just the "recently-changed" records from my database, that's not a problem, but is there a way to update only those records in the QVD file which holds all the client records?

       

      I can do a Load followed by a Concatenate and I can also use WhereNotExists to add *new* clients.  However, I can't work out how to drop the *updated* clients, and I end up with two rows. for those records.

       

      Is there a way to either delete, mark as deleted, or drop individual records in a QVD?