topic Re: Incremental loading in QlikView

Incremental loading

Mon, 18 Nov 2013 06:30:46 GMT

Hi,

I am new to qlikview,I would want to know how incremental loading is done in qlikview.Can anyone please let me know about it.I did find a line of code like where not exists(ID) when i was trying to google about it.So please let me know when where and why not exists function will be used along with the procedure of incremental loading

Re: Incremental loading

MK_QSL — Mon, 18 Nov 2013 06:47:25 GMT

There are few videos available on youtube. Try search them and stll

have any problem, lets know

Re: Incremental loading

Mon, 18 Nov 2013 07:04:24 GMT

Hi Anushree,

A link attached regarding the incremental Load sample example.

Hope it Helps You to better understand the Incremental Load.

http://community.qlik.com/message/12730#12730

Regards,

Ravikant.

Re: Incremental loading

er_mohit — Mon, 18 Nov 2013 07:13:21 GMT

see the attached file then it clears you why we use it

Re: Incremental loading

Mon, 18 Nov 2013 10:32:43 GMT

Hi Mohit, i did go through the attached sample.So my understanding is that in the last part we have been performing a join between the master and the transaction table and loading those rows from the master wherein the pid in the master is not the same as pid in the transaction.Please let me know if my understanding is correct

Re: Incremental loading

er_mohit — Mon, 18 Nov 2013 11:22:26 GMT

yup

right that's why to append the rows we used this type of incremental load