8 Replies Latest reply: Nov 12, 2014 9:55 AM by phillip colbert RSS

    Append Data to An Existing QVD

    phillip colbert

      Hi,

       

      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).

       

      QVDA:

      LOAD * From $(vMyPath)QVDA.qvd(qvd);

       

      QVDB:

      CONCATENATE(QVDA)

      LOAD * From $(vMyPath)QVDB.qvd(qvd);

       

      Anyone offer any advice/help?

       

      cheers