Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

What is the difference between Partial reload and incremental reload?

Hi All,

What is the difference between Partial reload and Incremental reload?

Thanks,

Attitude

4 Replies
chandashok
Contributor III

What is the difference between Partial reload and incremental reload?

Hi

     http://community.qlik.com/message/29414#29414

     the above link will have the answer for your doubt

Regards

Ashok

Not applicable

What is the difference between Partial reload and incremental reload?

Thanks Ashok!

I request other user to give some differences between them!

Not applicable

Re: What is the difference between Partial reload and incremental reload?

Hi At titude,

Partial reload executes a specific part of your sciprt, which will refresh a certain table.


Incremental reload is to add only new transactions to a transaction table.

Using Incremental reload script decreases the reload time, as it loads only new records from a data source instead of the complete table.

Regards,

Snehal Nabar

Not applicable

Re: What is the difference between Partial reload and incremental reload?

Hi,

Here is good example and use of Partial Reload:

Save Time and Patience with Partial Reloads in QlikView Get Business Intelligence Software

In the past, you may have added an “Exit Script” statement in your script editor to load only a few tables, or you may have commented out tables you didn’t want to load.

Fortunately, there is a faster way that lets you add or replace new tables without reloading the whole script. You can pick and choose the tables you want to reload while still keeping other tables in memory. On the bottom of the File menu you may have noticed the Partial Reload option. This is how it’s used:

1.  There are 2 script statements that are used for Partial Reloads. “Add” and “Replace”

  • ADD – Adds an additional table without reloading the entire script. If the table already exists, rows from this run will be appended.
  • REPLACE – Replaces a table without reloading the entire script.

2.  The three examples below show the difference in loading tables.

Table1:

LOAD
SalesPerson,
Territory,
Amount
FROM
[sales.qvd] (qvd);

Table2:

ADD LOAD
SalesPerson,
Territory,
Amount
FROM
[sales.qvd] (qvd);

Table3:

REPLACE LOAD
SalesPerson,
Territory,
Amount
FROM
[sales.qvd] (qvd);

3.  In the script editor, use the “Add” or “Replace” statement before the LOAD Statement.

4.  Save and close the script editor

5. Go to the File menu and Select “Partial Reload”

Now the only table(s) that are reloaded will be the ones with a “Add” or “Replace” statement. Happy QlikView learning!