Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
singhcv123
Contributor
Contributor

qlik update and delete...

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 .

2 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Refer this link

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.