Partially reloading data

[#1]

Dear all,

I'm loading data from a database like this (actually more columns, but this is for example purposes):

ODBC CONNECT32 TO [DWH_P3.world;DBQ=DWH_P3] (XUserId is ceMTEIBHWBMOTcAHbCTCEBdLTKREFLFJDKRGVOBX, XPassword is dHUEEYVMQbcSWYIGTRRA);
LOAD "DDA_KEY_TSK":

SQL SELECT *
FROM "LAB_SERVICES"."FBI_RAPPORTAGE_FO_VERZOEKEN";

This all works fine but I loading takes quite a lot of time. Could anybody elaborate on how I can only reload the new data when I refresh?

[tresB]

May be using :Incremental Load

[Jason_Michaelides]

There are lots of posts in here - search for "Incremental Load". The F1 Help is also pretty good for this. Are you familiar with the concept of Incremental Loads?

[ashfaq_haseeb]

Hi,

Have a look at attached document in below post.

Incremental Load Scenarios.pdf

Incremental Load in Qlikview - Sources

Regards

ASHFAQ