Load

qlikview979 — Tue, 05 May 2015 10:53:15 GMT

Hi experts,

What is resident load ? why we are using 'ADD ONLY' keyword before load ?

Re: Load

hubertdudek — Tue, 05 May 2015 10:55:26 GMT

Resident is load from table which already exists (was laoded before).

ADD ONLY can be used in partial reload / concatenate.

Re: Load

Ralf-Narfeldt — Tue, 05 May 2015 12:46:59 GMT

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.

Re: Load

Tue, 05 May 2015 13:53:32 GMT

Hi,

Resident load:

if we need to create modification from already loaded and existed data, we use that key word in scripting.

topic Re: Load in QlikView

Load

Re: Load

Re: Load

Re: Load