Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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 QVD
Sales:
LOAD
*
FROM
[$(QVD_FilePath)$(FileName).qvd] (qvd)
;
LET
LastRowID = Peek('RTL_TRN_ID', -1, Sales)
;
DROP
TABLE
Sales;
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;
Hi
Thanks..I did the same thng And I finished ....