3 Replies Latest reply: Apr 21, 2015 8:45 AM by Shiva Reddy RSS

    Incremental Load from QVW

      Hey Everyone.


      First let me paint the picture:




      I have 1200 XML's daily which i load into a file named Database.qvw

      I have created a second file named CreateQVD.QVD (will only use it once)


      In this file i create the QVD database for all my data.


      Now i want to report over this in a third file named: Report.qvw.


      So i can simply load the QVD files into my Report.qvw.

      however tomorrow i will have another 1200 XML's.


      These again will be loaded into Database.qvw so tommorow when updating my Report.qvw i need it to:


      1, Load the old QVD

      2, Incremental Load the Database.qvw

      3, save a new QVD over the old one.


      The reason i want to do it this way is because we would like to delete the XML's after a given time while still keeping the data in a QVD.


      This is because on a yearly basis we would receive 438 000 XML's wich would be a pain to the server.


      Could anyone help me with the syntax for this?
      Do i need to binary load the Database.qvw or how can i achieve this?