qlik update and delete...

singhcv123 — Sun, 12 Feb 2017 14:59:19 GMT

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 .

Re: qlik update and delete...

vinieme12 — Sun, 12 Feb 2017 15:52:24 GMT

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);

Re: qlik update and delete...

vinieme12 — Sun, 12 Feb 2017 16:00:08 GMT

Refer this link

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

topic qlik update and delete... in QlikView

qlik update and delete...

Re: qlik update and delete...

Re: qlik update and delete...