topic Re: Partial reload in QlikView

Partial reload

Mon, 09 Jun 2014 17:58:48 GMT

Hi Community,

I'm new to qlikview and may I've knowledge on Partial reload and how it helpful in real time?

Please can anyone explain on this in detail.

Thanking You!

Sattish

Re: Partial reload

its_anandrjs — Mon, 09 Jun 2014 18:15:13 GMT

Assume you are working on the qlikview and there is a data model and you want to reload only single table not whole tables because they take much time. Then in this cases you load a data of only that table and in another case suppose you want to add another table into model then you have do like below script and Put ADD prefix before the load statement and from file menu click on the Partial Reload .

Table1:

Load * From Location;

Table2:

ADD

Load * From Location;

Re: Partial reload

Bill_Britt — Mon, 09 Jun 2014 18:57:45 GMT

Hi,

This is the way I would explain it when I was training. You have a data model and most of the data is static or maybe updates once a month. However, you have one or two tables that are updated daily. In your load script you would put Replace in front of the load statement and when you do a partial reload only the tables that have replace load are reloaded.

Products:

REPLACE LOAD

CategoryID,

ProductID,

ProductID as ProductIDRecordCounter,

ProductName,

QuantityPerUnit,

SupplierID,

UnitCost,

//UnitPrice,

UnitsInStock,

UnitsOnOrder;

SQL SELECT *

FROM Products;