Reload data from one source while keeping data from other
Hello Community,
I'm quite new to Qlikview and I'm having trouble to solve this problem:
Within the script I load data from different sources like access-tables and so on.
Because the amount of data is quite large it takes time to load. Therefore I would like to "reload" the data which changes on a daily basis, while keeping the data that changes once a month.
Is that possible - or doesn't Qlikview work that way?
I tried to control which data to load within the script by setting differnt variables:
if(variable_daily=true) then
load ...
from...
endif
if(variable_monthly=true) then
load ...
from...
endif
The problem is, that QlikView deletes all data before running the script. If variable_daily=true and variable_monthly=false then the montly data is gone and the daily is loaded.
It is possible in Qlikview. You need to imeplement the Incremental loading concepts for this. Go through the Incremental Loading concepts in Qlikview help and Reference Manual file.
Also you can find number of examples in Qlikview community.
Depending on your requirements you can also use the function ADD infront of the LOAD statement and then use the "Partial Reload" option in the File menu. When doing this, Qlik won't delete anything but add the table where you use the ADD function. Ex:
T1:
LOAD * FROM file;
T2:
LOAD * FROM file2;
With the above, if you do the normal reload, Qlik will erase everything and reload data from file and file2. Now let's suppose T1 doesn't change and it's heavy and you don't want to reload it everytime and you only load T2, you can do:
T1:
LOAD * FROM file;
T2:
ADD LOAD * FROM file;
Then go to File --> Partial Reload. Here Qlik will keep T1 and load only those tables that have ADD infront of the LOAD statement (T2).
