I am facing problem with Incremental load(insert and update).
I have data initialload.xlsx file with 4 records for initial load and incrementalload.xlsx file contains 4 intial load's updated records and 2 new records. After executing incremental script for first time, when i am displaying QVD content in Table of another app, it shows only 2 new records from incremental.xlsx. After executing incremental script second time, O records is displayed. But After that whenever i execute incremental scripts, it shows proper 6 records , 2 new +4 initial load's data with updated values. This is what actually expected when i execute incremental script first time. I have used modification time for fetching new records and composite key "Voucher Number"&' '&"Account Code" for filtering updated the record. Please suggest some solution to come out from this problem.
"Accounting Site Code",
Timestamp(Timestamp#("Approved At",'DD-MMM-YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as "Approved At",
"Voucher Date (Date)",
"Voucher Number"&' '&"Account Code"
(ooxml, embedded labels, table is intialload);
store InitialLoad into [lib://sampledata/jvqvd1.qvd] (qvd);