topic Re: incremental data in QlikView

incremental data

Mon, 16 Jun 2014 05:57:17 GMT

Hi All

I created a qvd with my data. then i concatenated the qvd with daily incremented data.

it is working fine. but if i modified my actual data that was not changed in my qvd instated of that i am getting more records on that id.

i know i wrote code for insert condition only. please help me how to write code for insert update and delete perspective.

Mon, 16 Jun 2014 06:00:53 GMT

Insert update and delete

swuehl — Mon, 16 Jun 2014 06:03:58 GMT

Go to http://robwunderlich.com/download and download the QV cook book.

There is well documented example of different kind of incremental loads incl. update contained.

SunilChauhan — Mon, 16 Jun 2014 06:08:04 GMT

you need to store back after concatenating then only will reflect in qvd

see the attached file

hope this helps