Partial Reload

[bharatkishore]

Hello ALL,

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

Regards,

R.Bharat Kishore

[kaushiknsolanki]

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

[bharatkishore]

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

[kaushiknsolanki · Accepted solution]

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  

[bharatkishore]

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

Regards,

R.Bharat Kishore

[bharatkishore]

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