Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;