A normal (non-partial) reload always starts by deleting all tables in the existing data model, and then runs the load script.
A partial reload will not do this. Instead, it keeps all tables in the data model and then executes only Load and Select statements preceded by an Add, Merge, or Replace prefix. Other data tables are not affected by the command. The only argument denotes that the statement should be executed only during partial reloads, and should be disregarded during normal (non-partial) reloads.
Environment:
QlikView
This command executes only the Load and Select (SQL) statements preceded by a Replace or Add prefix. Other data tables remain unaffected by the command.
Add
The add prefix can be added to any Load, Select (SQL) or Map ... using statement in the script. It is only relevant 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 map...using statement causes mapping to take place also during partial script execution.
The syntax is:
add [only] (loadstatement |selectstatement |mapstatement)
where:
only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial) reloads.
Example:
Tab1:
LOAD Name, Number FROM Persons.csv;
ADD LOAD Name, Number FROM newPersons.csv;
Replace
The replace prefix can be added to any Load, Select (SQL) or Map ... using statement in the script. The replace load/replace select statement has the effect of dropping the entire QlikView table, for which a table name is generated by the replace load/replace select statement, and replacing it with a new table containing the result of the replace load/replace select statement. The effect is the same during partial reload and full reload. The replace map...using statement causes mapping to take place also during partial script execution.
The syntax is:
replace[only](loadstatement |selectstatement |map...usingstatement)
where:
only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial) reloads.
Example:
Tab1:
Replace load * from File1.csv;
Related Content:
Partial reload