topic Re: Partial Reload in QlikView

Partial Reload

Thu, 12 Jun 2014 16:16:46 GMT

When you do a partial reload (Ctrl-Shift-R), what part of the data gets reloaded? Is it determined solely by the script such as using "Replace" and "Only" or some other method?

Re: Partial Reload

alexandros17 — Thu, 12 Jun 2014 16:25:25 GMT

Take a look at instruction Add and Only (you will find them searching for LOAD)

Re: Partial Reload

fkeuroglian — Thu, 12 Jun 2014 16:34:28 GMT

Hi, see this example

if you want to do partial reload, you have to put ADD before the load, see this example

Table1:

------

Table2:

--------

Table10:

--------

Table11:

ADD LOAD * INLINE [

Key1, Value1

A, 100

B, 200

C, 100

];

Now if you use Partial reload, it just reloads the Table11.

good luck

Fernando

Re: Partial Reload

IAMDV — Thu, 12 Jun 2014 16:49:45 GMT

Hi,

I've made 2 part video tutorial on Partial Reload which includes "Only" & "Replace" prefix as well.

http://qlikshare.com/?s=Partial+reload

I hope this helps!

Cheers,