30 b) Incremental load part 2

Hello Everyone,
Hope you guys are doing well. Stay safe.

This video will walk you through the incremental load in Qlik Sense.
This is part-2 of incremental Load.

Definition: Loading the new /updated records without loading the full data is called Incremental load.
Points to remember:
Here we will be doing Insert-Update-Delete

Step1: Load the data and store in in the QVD
Step2: Find the number of rows present in the QVD loaded in Step1 (used preferably use ID column i.e. a column do not have NULL value.)
Store the value in a variable.
To do this I have used NoofRows function in Qlik, there are many other ways to achieve this as well.
Step3: No hit the Database (which now will have some new entries) load the
data which came after the NoofRows values stored in the variable
Step4: Now load back the QVD and used 'not exist' function to load only those data which doesn't match with the data loaded in Step3 and concatenate it with the data loaded in Step 3 .

Link for the Document:

Please follow me on:

[sujatarao]

What if we do the incremental load and transforming the data, we would not like to transform the whole data again, how to apply the transformation in only incremental part ?

[snehav]

please make mouse icon visible in future videos as that will help beginners to know where to click