Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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;
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
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.
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