Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Reload or Partial Reload

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Reload or Partial Reload

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.


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Reload or Partial Reload

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;



talk is cheap, supply exceeds demand
Not applicable

Re: Reload or Partial Reload

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

MVP & Luminary
MVP & Luminary

Re: Reload or Partial Reload

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.


talk is cheap, supply exceeds demand

Re: Reload or Partial Reload

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