topic Re: Functionality of Add Load in QlikView

Functionality of Add Load

Thu, 19 Dec 2013 05:23:18 GMT

Hi All,

What is the functionality of ADD Load in QlikView, I am find explanation but I am not understandable,please any give me explanation little brief with example, when you are generally use?

/* Add Load is used to append or concatenate the data from one table to other table. 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. */

Re: Functionality of Add Load

jagan — Thu, 19 Dec 2013 05:39:18 GMT

Hi,

Add keyword is use for Partial reloading of the data, suppose you have 5 tables already in your datamodel and you need to add one more table, then you usually add the script and reload all the tables. By using Partial Reload you can load only the new table to the existing data model.

Examples from Qlikview Help file:

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 QlikView table Tab1. Data from NewPersons.csv is then concatenated to the same QlikView table. See Concatenation.

Tab1:

SELECT Name, Number FROM Persons.csv;

ADD LOAD Name, Number FROM NewPersons.csv Where not exists(Name);

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

Hope this helps you.

Regards,

Jagan.

Re: Functionality of Add Load

Anonymous — Thu, 19 Dec 2013 05:41:17 GMT

Thanks Jagan !!

Re: Functionality of Add Load

Fri, 23 May 2014 20:28:26 GMT

Isnt that the same as concatenate?

Re: Functionality of Add Load

jagan — Mon, 26 May 2014 02:23:26 GMT

Hi,

It is similar to Concatenate, the only difference is, if you just want to concatenate some rows to the existing table without reloading the entire dashboard then this method is used. Using this method it do not reload other tables in the data model it just concatenates/or create new tables to the existing datamodel.

Regards,

Jagan.