Hi.
I have created an app that loads data incrementally, ie updates records when data is change in a column, is identified via ID and adds new records via: not Exists ([ID]).
Unchanged records do not happen except the loaddate is updated.
On the first tab, a basic qvd is created and the term: load_FOM is created and must contain the date of the record's first load.
loads files in the following order:
first load: [lib: //sap/sap.xlsx
Second load: [lib: //sap/sap_add.xlsx]
So after the second load, the column: date_FOM should contain the date of the record first load for each record, loaddate should contain the last load date.
I do not get it and hope someone knowledgeable can look at the app and give suggestions on how it should go.
i attache the app and xlsx.
Regards.
