Reload or Partial Reload

[#1]

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

[Gysbert_Wassenaar]

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;

[#3]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[its_anandrjs]

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