Add The add prefix can be added to any load, select or map...using statement in the script. It is only meaningful during partial reloads. During a partial reload the QlikView table, for which a table name is generated by the add load/add select statement (provided such a table exists), will be appended with the result of the add load/add select statement. No check for duplicates is performed. Therefore, a statement using the add prefix will normally include either a distinct qualifier or a where clause guarding duplicates. The add map...using statement causes mapping to take place also during partial script execution.
I have to save values from the loading of yesterday with the load of today.
What I want is, that the table1 has only today() as date and in table3 are all the other date before today() when I have load the script.
It sounds to me like you could be comingling two different concepts that have similar names, but need to be identified clearly to prevent confusion.
Partial reload - is the execution of only a portion of script, in which statements that are "activated" during a partial reload have been marked as such by partial reload keywords ADD/REPLACE/ONLY.
Incremental reload - refers to the technique of taking an earlier data extraction and combining it with a more recent refresh against the source systems, and only downloading the delta between the prior extraction and the current process, in order that the full breadth of all data involved is not required to be downloaded from the sources every time the script is executed.
To confuse matters, it is possible to perform an INCREMENTAL load while performing a PARTIAL reload, but I'm expecting that is not the permanent way you want to structure your script.
A basic incremental load could be formed like this (and doesn't require any partial reloading):
//table ARCHIVE needs to have all the records you preserved from earlier loads, so they can be combined with today's extraction
LOAD sales, orders, date FROM ARCHIVE.QVD WHERE Num(date) < Num(Today());
//Concatenate the most recent set of records to the ARCHIVE
Today() as date
//Store new archive to replace the old one STORE * FROM ARCHIVE INTO ARCHIVE.QVD (qvd);
Partial Reload is used whenever you just want to add some new data without reloading all other tables. Suppose in your Qlikview file you have 10 tables which has millions of records, if you want one new table then you need to add the script, if you give normal reload it will reload all the 10 tables and the new table. Suppose if you don't want to reload the old 10 tables and just want to add new table then Partial Reload would be helpful.
This can done by using the ADD or REPLACE attribute to LOAD statement.
ADD LOAD * INLINE [
REPLACE LOAD * INLINE [
and if ur okey with the answer please select the correct answer . so that people stops their discussion