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.
