4 Replies Latest reply: Jan 8, 2014 2:13 PM by Robert Fishel RSS

    Implement Incremental Load

    Agnivesh Kumar

      I have a excel file like

       

      ID     Name    address

      1           a              b

      2          b             rgfr

      3          c            dgr

      4          d           gfrg

       

      i have loaded this file in qlikview , now when i reload the script then it loads all the data , now please tell me how to implement incremental load on this type of table. Because there is no timestamp field but ID is Primary Key. Provide me script also.

      thanks.

        • Re: Implement Incremental Load
          Manideep Hv

          Hi

           

          Store  MAX(ID) value in a variable.

           

          Next time when u get data, get only those records which are greater than MAX(ID) and concatenate to previous table.

           

          So that every time you reload you will get only incremented records.

           

           

          Table1:

          LOAD ID,

               NAME

          FROM

          [F:\Manideep\qlikview practice\Incremental_Load\Incremental_Load.qvd]

          (qvd);

           

           

          LET vMaxID = Peek('ID',-1,'Table1');

           

           

          Concatenate

          LOAD ID,

               NAME

          FROM

          [F:\Manideep\qlikview practice\Incremental_Load\Data.xlsx]

          (ooxml, embedded labels, table is Sheet1)

          Where ID>$(vMaxID);

           

           

          STORE Table1 into F:\Manideep\qlikview practice\Incremental_Load\Updated_Data.qvd;

           

           

          Hope this helps

           

          Regards,

          Manideep