1 Reply Latest reply: Jun 2, 2015 11:58 AM by Piet Hein van der Stigchel RSS

    Incremental Load

      if i am using the incremental load for the first time and i don't know whether there is qvd file is present or not. can i use the following script for the update.

       

      Temp:

      LOAD

           ID,

          Name,

          Department,

          Gender,

          `Modified Date`;

      SQL SELECT *

      FROM Details

      where [Modified Date] > $(lastReloadTime);

       

       

      If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then

      CONCATENATE (Temp)

      LOAD

          ID,

          Name,

          Department,

          Gender,

          `Modified Date`

      FROM qwe.QVD(qvd) where not exist(ID);

      ELSE

      LOAD ID,

          Name,

          Department,

          Gender,

          `Modified Date`;

      SQL SELECT *

      FROM Details;

      END IF

       

      store Temp into qwe.QVD(qvd);

       

      for doing the inserts the below script is working

       

      If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then

      Details:

      LOAD

          ID,

          Name,

          Department,

          Gender,

          `Modified Date`

      FROM TST.QVD(qvd) where not exist(ID);

      ELSE

      Details:

      LOAD ID,

          Name,

          Department,

          Gender,

          `Modified Date`;

      SQL SELECT *

      FROM Details;

      END IF

       

      CONCATENATE (Details)

      LOAD

           ID,

          Name,

          Department,

          Gender,

          `Modified Date`;

      SQL SELECT *

      FROM Details

      where [Modified Date] > $(lastReloadTime);

       

      store Details into TST.QVD(qvd);