Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pawwy1415
Contributor II

how to implement incremental load in Qlik sense

Hi,

Please can you give script example to implement load in qlik sense. e.g I will be using CREATED_DATE to implement incremental load and it will be update daily.

I have 5 table and this field is not there in all table..

data is loaded 1st into QVD for each table and then model is created.. please can you give example where this incremental load will be implemented and script example.

Thanks

2 Replies
gompa786
Contributor III

Re: how to implement incremental load in Qlik sense

Hi Kumar,

You are saying you have 5 tables do you mean all 5 are fact tables which should be joined to become one table ???

ideally we should do an incremental load on the final fact table of your data model... Please find a link below with very good example of the incremental load script.. As a standard in Finance people follow the insert and update method of the incremental load process.. Link below .. hope this helps..

http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

undergrinder
Valued Contributor II

Re: how to implement incremental load in Qlik sense

Hi Kumar,

This link will help you:

Loading new and updated records with incremental load ‒ Qlik Sense

It depends, what type of data do you have.

If the source data is a database table then query the timestamp dinamically and append the qvd.

G.

Community Browser