topic Partial Reload in QlikView

Partial Reload

bharatkishore — Wed, 01 Feb 2012 07:34:15 GMT

Hello ALL,

Can anyone tell me howe to do Partial Reload.If possible please attach your qlikview file.

Regards,

R.Bharat Kishore

Partial Reload

kaushiknsolanki — Wed, 01 Feb 2012 07:42:26 GMT

Hi,

Partial reload will work only if the load statement is preceded by "Add" or "Remove" keyword. Other tables will remain same.

The use of this can be, for example if you want to add one more table into existing datamodel without loading full script.

For more information you can have a look at the help available in QlikView.

Regards,

Kaushik Solanki

Partial Reload

bharatkishore — Wed, 01 Feb 2012 07:46:56 GMT

HI Kaushik,

Thanks a Lot for your Reply.I took two tables from load * inline.I Will Clearly write so that you can understand.

//***********Table1***********

Table1:

LOAD * INLINE [

A, B

1, 2

3, 4

];

//Table2:

LOAD * INLINE [

C, D

1, 2

3, 4

5, 6

];

Now Pls say to mo How to do.

Regards,

R.Bharat Kishore

Partial Reload

kaushiknsolanki — Wed, 01 Feb 2012 07:55:36 GMT

HI,

Now consider you have this script

Table1:

LOAD * INLINE [

A, B

1, 2

3, 4

];

Table2:

LOAD * INLINE [

C, D

1, 2

3, 4

5, 6

];

Now when you reload, above full script will get loaded. No change the script as below.

Table1:

LOAD * INLINE [

A, B

1, 2

3, 4

5, 6

];

Table2:

add LOAD * INLINE [

C, D

1, 2

3, 4

5, 6

7,8

];

Now when you perform partial reload, only table2 will be loaded. Table1 will contain only data till 3,4.. 5,6 will not be added.

Hope its clear.

Regards,

Kaushik Solanki

Partial Reload

bharatkishore — Wed, 01 Feb 2012 08:01:54 GMT

Thanks a lot Kaushik.Thanks for the reply.Its the Correct answer.Thank u so much.

Regards,

R.Bharat Kishore

Partial Reload

bharatkishore — Wed, 01 Feb 2012 12:57:05 GMT

Kaushik i have one more question.If i add data in table1 then also the data is loading.But if i add data in table1 it should not load it should only load table 2 data.

Regards,

R.Bharat Kishore