1 Reply Latest reply: Feb 8, 2017 4:50 AM by Vineeth Pujari RSS

    store historic Data

    gaurav gopale

      Hi

      I have the following table

       

      IDPo TypePo DateProcess DateValue
      1A01/09/201601/01/20171000
      2A05/10/201601/01/20174000
      3B06/11/201601/01/20175000

       

      in the above table we have Process Date which has 01/01/2017 ie jan2017 data

       

      in feb2017 the above table will be replaced by feb data.

      so in Jan in have to create on qvd of jan2017 and in feb2017 again i have to create qvd of feb2017 and concat to jan2017 qvd

       

      so every month the data will be concat

       

       

       

       

       

       

      thanks in advance

        • Re: store historic Data
          Vineeth Pujari

          So what do you need help with buddy?

           

          Generally we would create an Archive QVD at the end of everymonth

           

          For example  at the end of Jan Create a QVD for example Archive.QVD

          then in Feb

           

          FACT:

          load

          Archive.QVD  

           

          concatenate

           

          Monthly:

          Load

          Feb.qvd

           

          IF today() = Monthend(today()) THEN

          Store FACT into Archive.QVD

          End IF

           

          Then in March you have both Jan+Feb data... hope this makes sense