topic Re: Reload or Partial Reload in QlikView

Reload or Partial Reload

Sun, 25 Nov 2012 09:00:50 GMT

I load one table

Table1:

load

from source

Now add second table

Table2:

load

from source

but i does not include it on reload activity i use partial reload but it not works does any one tell me about how to use it.

Thanks

Re: Reload or Partial Reload

Gysbert_Wassenaar — Sun, 25 Nov 2012 10:19:19 GMT

If your two source tables have the same fields and you don't specifically tell Qlikview to not concatenate the tables then all the records from both loads end up in Table1. This is usually the right thing to do. If you want to know which record came from which source add a field to store that information.

Table1:

Load *,

'This record comes from Source1' as Source

from source-1;

Load *,

'This record comes from Source2' as Source

from source-2;

Re: Reload or Partial Reload

Sun, 25 Nov 2012 14:32:16 GMT

Thanks, But sorry i am not properly explain my requirement it is like that

I load a table say

Table1:

load

Field1,

Field2,

Field3,

...

From source;

15 rows loaded in the reload

Table2:

load

columnA,

columnB,

columnC,

From source;

25 rows loaded inthe reload

But from 2 reload when i do reload i only want to reload the second table, i am not want to reload the Table1 because it is already loaded, I want to load only Table2.

Thanks

Re: Reload or Partial Reload

Gysbert_Wassenaar — Sun, 25 Nov 2012 14:43:16 GMT

Like this:

Table2:

ADD load

columnA,

columnB,

columnC,

From source;

Then choose partial reload instead of reload. If you want to replace Table2 instead of adding the records to it the use REPLACE load.

Re: Reload or Partial Reload

its_anandrjs — Sun, 25 Nov 2012 15:01:36 GMT

Hi,

Use some thing like

Table1:

load

From Source;

Table2:

Add

load

From Source;

Put Add syntax above the load syntax of table for table that you want to load only like Table2 here

And then from File Menu -> Partial Reload other wise use Ctrl + Shift + R

Regards,

Anand