1 Reply Latest reply: Jul 26, 2016 9:39 AM by Jonathan Dienst RSS

    how to update the data

    Naveen N

      i have made a qvd using incremental load i have to update a selected date update in the file which is already incremental loaded in qvd how can i do in qlikview

        • Re: how to update the data
          Jonathan Dienst

          You need to provide more information if you want specific help, but it is quite easy to load a qvd (all the fields except that one that needs to change) and the new value for the field that needs to change:

           

          Data:

          LOAD field1,

               field2,

               'New value' as field3,

               field4

          FROM MyDataFile.qvd (qvd);

           

          STORE Data into MyDataFile.qvd (qvd);

           

          I suggest that you save a backup of the qvd before running this script.