Incremental Load in qliksense

[Namita]

Hi,

I am new to Qliksense.  And I want use Incremental load in my script.I have created 5 QVDs and loaded the data from  the same by joining (Left Keep)  the tables in transform layer. And the Modified date which is used to recognize new records  is in only in 1 table. So in this case how can I use incremental load for all the other tables.

Can anyone help me with this

[JordyWegman · Accepted solution]

Hi Namita,

Do you have a unique key in your table (QVD)? 

If no, create one.

If yes, use this key in your load to your database:

Database:
Load
 *
From [YourDatabase]
Where not Exists %Key
;

Then store this information as an increment and add the new added keys to the 'overall' key table so you can do the same load tomorrow and don't load the data from today again.

Jordy

Climber

[Namita]

Thanks Jordy.... this worked

[JordyWegman]

Great, please mark the post as solved so other people can see the solution!

Jordy

Climber