I have one table with an initial load of the entire database called EKPO_Initial. I have a second database that only contains the values from today called EKPO_Diff.
What I want to do is:
1. Load all values from EKPO_Initial that are NOT in the EKPO_Diff
2. Add the new rows from EKPO_Diff together
I already tried:
load * FROM [lib://qvd-Dateien (fliesen-zentrum_qlik-admin)/EKPO_Differential.qvd]
load * FROM [lib://qvd-Dateien (fliesen-zentrum_qlik-admin)/EKPO_InitialLoad.qvd]
where not exists(EBELN_EBELP);
This results in the final table to have only the number of rows as EKPO_Initial.