qlik update and delete...

[singhcv123]

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 .

[vinieme12]

If the Person.QVD is the Archive QVD then it should be Not Exists(UID)

load * from

$(vQvdFileLocation)Person.QVD(qvd)

where NOT Exists(UID);

[vinieme12]

Refer this link

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/