topic Load partial data in QlikView

Load partial data

Anonymous — Wed, 07 Mar 2012 10:06:49 GMT

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

Wed, 07 Mar 2012 10:15:41 GMT

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 — Wed, 07 Mar 2012 10:27:16 GMT

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 — Wed, 07 Mar 2012 10:38:23 GMT

Hi,

Try with the below script

Table1:

LOAD *;

SQL SELECT ...... FROM X

Table2:

Replace LOAD *;

SQL SELECT ...... FROM Y.

Celambarasan