Update resident table in Partial reload

Wed, 19 May 2010 06:22:49 GMT

Hi, I have a QV script that loads a huge table and just that table. This table has a unique identifier (integer) as the key.

Several times per hour records get updated in that table in the database. For now I don't care about inserted or deleted records, just the updated ones.

I know how to get the records that were updated using a TIMESTAMP and how to save that timestamp using a variable within the QlikView document.

Now, I want to be able to have a Partial Reload script that can get those updated records from the database and then update their counterparts in the huge resident table. In other words, I want to selectively update records in the resident table that is already present when the partial reload starts.

I know a full reload will solve the problem but it is too expensive for our requirements.

I'm pretty sure QV has something to work in memory but I'm just a novice.

Thanks gurus.

topic Update resident table in Partial reload in QlikView

Update resident table in Partial reload