Skip to main content

Add

ON THIS PAGE

Add

The add prefix can be added to any LOAD, SELECT or map...using statement in the script. It is only relevant during partial reloads.

Syntax:  

Add [only] (loadstatement | selectstatement | mapstatement)

 

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.

Arguments:  

Argument Description
only An optional qualifier denoting that the statement should be disregarded during normal (non-partial) reloads.