Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

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

3 Replies
gompa786
Creator III
Creator III

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
Specialist II
Specialist II

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.

taherk
Contributor
Contributor