I’m having an awful lot of trouble to do something that on paper seems very simple. I wish to append the data from one QVD to another.
QVD (A) runs daily and only ever contains 1 days worth of data (its SQL source is truncated daily). I wish to append this data daily to a new QVD (B)
And I only ever want to append the data to B from A that doesn’t already exist in B.
If I can get this working QVD B will allow me to trend my data as it’ll store data by the day.
So far I’ve got the following but I don’t think it’s appending correctly, and I also need the NOT EXISTS statement which im not sure how to apply as I cant do a simple test on the Primary Key (I need to test the entire row of data to check if it already exists).
Keep in mind that you only need to create the KEY field in the QVDA once. After the first run you need to comment out (or remove) that first load statement. After that the QVDB load statement creates the KEY field for the new records.