topic Re: Partial reload in QlikView

Partial reload

Wed, 31 Mar 2010 11:47:23 GMT

What is the partial reload??

How can i use the partial reload???

and when can i use??

Thanks

Partial reload

Wed, 31 Mar 2010 11:57:19 GMT

hi,

please see QV help:

Add
The add prefix can be added to any load, select or map...using statement in the script.
It is only meaningful during partial reloads. 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 add map...using statement causes mapping to take
place also during partial script execution.

Look also for REPLACE.

Good luck!

Rainer

Partial reload

Thu, 07 Jul 2011 11:40:24 GMT

Hi,

I have to save values from the loading of yesterday with the load of today. I have played with the ADD and REPLACE function, but the result wasn't what I'm expected.

I have the following short scriptexample:

table1:

REPLACE LOAD

sales,

orders,

today() AS date,

RESIDENT abc;

RENAME TABLE table1 TO table2;

table3:

ADD LOAD

sales,

orders,

date

RESIDENT table2;

Now, I have table2 in my choice but not table3 - with partial loading.

How can I otherwise save the values from table1?

What I want is, that the table1 has only today() as date and in table3 are all the other date before today() when I have load the script.

Re: Partial reload

evan_kurowski — Tue, 05 Aug 2014 17:39:10 GMT

Hello TXETXU TXETXU / Vicky_Qlik,

vicky_qlik wrote:

Hi,

I have to save values from the loading of yesterday with the load of today.

...

What I want is, that the table1 has only today() as date and in table3 are all the other date before today() when I have load the script.

It sounds to me like you could be comingling two different concepts that have similar names, but need to be identified clearly to prevent confusion.

Partial reload - is the execution of only a portion of script, in which statements that are "activated" during a partial reload have been marked as such by partial reload keywords ADD/REPLACE/ONLY.

Incremental reload - refers to the technique of taking an earlier data extraction and combining it with a more recent refresh against the source systems, and only downloading the delta between the prior extraction and the current process, in order that the full breadth of all data involved is not required to be downloaded from the sources every time the script is executed.

To confuse matters, it is possible to perform an INCREMENTAL load while performing a PARTIAL reload, but I'm expecting that is not the permanent way you want to structure your script.

A basic incremental load could be formed like this (and doesn't require any partial reloading):

//table ARCHIVE needs to have all the records you preserved from earlier loads, so they can be combined with today's extraction

[ARCHIVE]:

LOAD sales, orders, date FROM ARCHIVE.QVD
WHERE Num(date) < Num(Today());

//Concatenate the most recent set of records to the ARCHIVE

CONCATENATE(ARCHIVE)

LOAD sales,

orders

Today() as date

RESIDENT abc;

//Store new archive to replace the old one
STORE * FROM ARCHIVE INTO ARCHIVE.QVD (qvd);

Re: Partial reload

Tue, 05 Aug 2014 18:04:36 GMT

Partial Reload is used whenever you just want to add some new data without reloading all other tables. Suppose in your Qlikview file you have 10 tables which has millions of records, if you want one new table then you need to add the script, if you give normal reload it will reload all the 10 tables and the new table. Suppose if you don't want to reload the old 10 tables and just want to add new table then Partial Reload would be helpful.

This can done by using the ADD or REPLACE attribute to LOAD statement.

ADD LOAD * INLINE [

Key1, Value1

A, 100

B, 200

C, 100

];

REPLACE LOAD * INLINE [

Key1, Value1

A, 100

B, 200

C, 100

];

and if ur okey with the answer please select the correct answer . so that people stops their discussion

Re: Partial reload

evan_kurowski — Tue, 05 Aug 2014 18:10:32 GMT

It should also be pointed out:

Full reload - dumps all the data in the application and rebuilds the entire data model from scratch.

Partial reload - keeps the existing data loaded into the .QVW and only modifies whatever portions of data as directed by partial reload statements.