Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to retrieve field value of last record of a qvd file

Hi,

I want to get the field value of one column of last record of a qvd file.

1 Solution

Accepted Solutions
Not applicable
Author

the following is used in our incremental load process: the Peek -1 is getting the last loaded ID



























// Find the highest RTL_TRN_ID in the QVD
Sales:
LOAD





*
FROM



[$(QVD_FilePath)$(FileName).qvd] (qvd)
;
LET



LastRowID = Peek('RTL_TRN_ID', -1, Sales)
;
DROP



TABLE

Sales;









View solution in original post

2 Replies
Not applicable
Author

the following is used in our incremental load process: the Peek -1 is getting the last loaded ID



























// Find the highest RTL_TRN_ID in the QVD
Sales:
LOAD





*
FROM



[$(QVD_FilePath)$(FileName).qvd] (qvd)
;
LET



LastRowID = Peek('RTL_TRN_ID', -1, Sales)
;
DROP



TABLE

Sales;









Not applicable
Author

Hi

Thanks..I did the same thng And I finished ....