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.

Partial reload is currently only supported by using the Qlik Engine JSON API.

Syntax:

Add [only] (loadstatement | selectstatement | mapstatement)

During a partial reload the Qlik Sense 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.

Example	Result
Tab1: LOAD Name, Number FROM Persons.csv; Add LOAD Name, Number FROM newPersons.csv;	During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. Data from NewPersons.csv is then concatenated to the same Qlik Sense table. During partial reload, data is loaded from NewPersons.csv and appended to the Qlik Sense table Tab1. No check for duplicates is made.
Tab1: SQL SELECT Name, Number FROM Persons.csv; Add LOAD Name, Number FROM NewPersons.csv where not exists(Name);	A check for duplicates is made by means of looking if Name exists in the previously loaded table data. Exists - script function During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. Data from NewPersons.csv is then concatenated to the same Qlik Sense table. During partial reload, data is loaded from NewPersons.csv which is appended to the Qlik Sense table Tab1. A check for duplicates is made by means of seeing if Name exists in the previously loaded table data.
Tab1: LOAD Name, Number FROM Persons.csv; Add Only LOAD Name, Number FROM NewPersons.csv where not exists(Name);	During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. The statement loading NewPersons.csv is disregarded. During partial reload, data is loaded from NewPersons.csv which is appended to the Qlik Sense table Tab1. A check for duplicates is made by means of seeing if Name exists in the previously loaded table data. Exists - script function

Example

Result

Tab1:

LOAD Name, Number FROM Persons.csv;

Add LOAD Name, Number FROM newPersons.csv;

During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. Data from NewPersons.csv is then concatenated to the same Qlik Sense table.

During partial reload, data is loaded from NewPersons.csv and appended to the Qlik Sense table Tab1. No check for duplicates is made.

Tab1:

SQL SELECT Name, Number FROM Persons.csv;

Add LOAD Name, Number FROM NewPersons.csv where not exists(Name);

A check for duplicates is made by means of looking if Name exists in the previously loaded table data.

Exists - script function

During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. Data from NewPersons.csv is then concatenated to the same Qlik Sense table.

During partial reload, data is loaded from NewPersons.csv which is appended to the Qlik Sense table Tab1. A check for duplicates is made by means of seeing if Name exists in the previously loaded table data.

Tab1:

LOAD Name, Number FROM Persons.csv;

Add Only LOAD Name, Number FROM NewPersons.csv where not exists(Name);

During normal reload, data is loaded from Persons.csv and stored in the Qlik Sense table Tab1. The statement loading NewPersons.csv is disregarded.

Exists - script function

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here