You can use the Resident predicate in a LOAD statement to load data from a previously loaded table. This is useful when you want to perform calculations on data loaded with a SELECT statement where you do not have the option to use Qlik Sense functions, such as date or numeric value handling.
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 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 awhere clause guarding duplicates. The map...using statement causes mapping to take place also during partial script execution.
