Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
May be using :Incremental Load
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?
Have a look at attached document in below post.
Incremental Load Scenarios.pdf
Incremental Load in Qlikview - Sources