topic Re: How to create Partial Load? in QlikView

How to create Partial Load?

jonesbrown — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am New to Qlikview

How to create Partial Load?

plese help.

Re: How to create Partial Load?

sergio0592 — Wed, 08 Aug 2018 08:06:35 GMT

Hi, what do you mean with partial load?

If it's just for gain reload time with not reload on the whole DB, with can use sample.

E.g if you want reload on 10% of your DB:

Sample(0.10) LOAD * ....

Re: How to create Partial Load?

kakani87 — Wed, 08 Aug 2018 08:10:09 GMT

In your load script, use Add keyword in front of load statement of a table like

Add load * from table

then go to UI view of your document and in file select Partial reload option or CTRL+Shift+R

Hope this is helpful.

Re: How to create Partial Load?

pooja_prabhu_n — Wed, 08 Aug 2018 11:58:47 GMT

Hi,

Partial Reload is useful when you just want to add some new data without reloading all other tables.

Load statements preceded by a Replace or Add prefix

Suppose in your Qlikview application if you have 5 tables, if you want to add one new table without reloading all the other tables then you can make use of add keyword in the script, it will load only new table .

Replace will replace existing data in the table with new data.

Refer this link:

Partial Reload Easy and Simple