topic Partially reloading data in QlikView

Partially reloading data

Wed, 07 Sep 2016 09:31:07 GMT

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?

Re: Partially reloading data

tresB — Wed, 07 Sep 2016 09:43:32 GMT

May be using :Incremental Load

Re: Partially reloading data

Jason_Michaelides — Wed, 07 Sep 2016 09:44:24 GMT

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?

Re: Partially reloading data

ashfaq_haseeb — Wed, 07 Sep 2016 10:05:56 GMT

Hi,

Have a look at attached document in below post.

Incremental Load Scenarios.pdf

Incremental Load in Qlikview - Sources

Regards

ASHFAQ