Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Basic differential load

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]
(qvd);

Concatenate
load * FROM [lib://qvd-Dateien (fliesen-zentrum_qlik-admin)/EKPO_InitialLoad.qvd]
(qvd)
where not exists(EBELN_EBELP);

This results in the final table to have only the number of rows as EKPO_Initial.

Labels (1)