Mastering Qlik Sense

Insert and update

This scenario is the same as the one before, but we will also consider updated records.

In the previous example, if you modified an existing record, you will have it duplicated as we concatenated all records from the existing QVD file to the new extracted records.

To consider new and updated records, we must add a line of code to the concatenate load statement as follows:

TRACE Appending stored records to  new ones.;ConcatenateLOAD * FROM c:\myQVD\Countries.qvd (Qvd)WHERE Not EXISTS(%Id);TRACE Storing modified qvd file.;

In this example, we added the following line of code:

WHERE Not EXISTS(%Id);</span>

This will make sure that we load from the previously stored QVD file only records that having been pulled from the source, ...