This content has been marked as final. Show 2 replies
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 .
$(vPerson_WID) + RecNo() as [Person WID],
$(vCreatedDate) as [Created Date],
$(vModifiedDate) as [Modified Date],
'$(vGuestFileName)' AS [Guest File Name],
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);
load * from
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 .