Incremental load: Update a column if it is null else keep origninal value
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.
