2 Replies Latest reply: Feb 12, 2017 11:00 AM by Vineeth Pujari RSS

    qlik update and delete...

    Virendra Chawra

      we are following data loading scenerio where we are getting files from ftp and everyday we need to load file (Update or delete) from already loaded files in QVD .

       

      Guest:

      Load

        $(vPerson_WID) + RecNo() as [Person WID],

        $(vCreatedDate) as [Created Date],

        $(vModifiedDate) as [Modified Date],

        '$(vGuestFileName)' AS [Guest File Name],

        *;

       

      Load $(vColumnDetails);

       

       

      LOAD UID,

           Title,

           firstName,

           lastName,

           gender,

           birthDate,

           addressLine1,

           addressLine2,

           addressLine3,

          

       

       

      FROM

      $(vCSVFileLocation)guest_20170110

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

      concatenate

       

      load * from

      $(vQvdFileLocation)Person.QVD(qvd)

      where Exists(UID);

       

       

      but i am not getting right output...

       

      before performing this update process QVD size was 23000 KB but after update statement only showing 63 kb...

       

       

      please suggest the right way to perform  the update statement .