Load partial data

[Anonymous]

Hi,

How do you go about loading a specific set of data.

for eg.

LOAD *;

SQL SELECT ...... FROM X

Now you have already loaded the above.

Then you add another LOAD:

LOAD *;

SQL SELECT ...... FROM Y.

Now when I want to reload I do not want to reload the 1st part since it is time consuming,

Is it possible to only load the second load and keep all the data in the Qlikview model.

Kind Regards

Razak

[#2]

Hi,

first use ADD or REPLACE in front of your load statement (see also QV help).

Second go to go to FILE => PARTIAL RELOAD or type CTRL+SHIFT+R.

Good Luck!

Rainer

[jagan]

Hi,

Use the following script

Table1:

LOAD *;

SQL SELECT ...... FROM X

Table2:

ADD LOAD *;

SQL SELECT ...... FROM Y.

While loading Table2 select Partial Load (Ctrl + Shift + R) or File -> Partial Reload option.

Hope this helps you.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

Try with the below script

Table1:

LOAD *;

SQL SELECT ...... FROM X

Table2:

Replace LOAD *;

SQL SELECT ...... FROM Y.

Celambarasan