5 Replies Latest reply: Apr 10, 2017 4:19 AM by Zied Ahmed RSS

    Historization with QVD

    Zied Ahmed

      Hello,

      I used a QVD to stock all data :

       

      ////*************set the qvd folder path************

      SET vQvdPath=C:\qvdtest;

       

       

      QVD:

       

       

      LOAD * FROM [C:\\qvdtest\QVD.qvd] (qvd) ;//source des QVDs historisés

      Concatenate:

       

       

       

       

      LIB CONNECT TO 'Microsoft_SQL_Server;

      LOAD

          * WHERE  "date"= Today()

           ;

          

      SELECT

      date,

      Statut

      Name,

           last_name

      FROM base.dbo."Table" 

       

      // ////*********store QVD**************

      STORE [QVD] into [$(vQvdPath)\QVD.qvd](qvd);

       

      Now i need the historization of the Statut result per month.

      how i can do it thank you

      Regards