I want to get the field value of one column of last record of a qvd file.
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 QVDSales:LOAD*FROM [$(QVD_FilePath)$(FileName).qvd] (qvd);LET LastRowID = Peek('RTL_TRN_ID', -1, Sales);DROP TABLESales;
Thanks..I did the same thng And I finished ....
Retrieving data ...