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

[#1]

Hi,

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

[#2 · Accepted solution]

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;

[#3]

Hi

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