Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is meant by partial reload? What is its use? Please explain!

Hi All,

What is meant by partial reload? What is its use? Please explain!

Thanks,

Attitude

22 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Partial Reload is used whenever you just want to add some new data without reloading all other tables.

Suppose in your Qlikview file you have 10 tables which has millions of records, if you want one new table then you need to add the script, if you give normal reload it will reload all the 10 tables and the new table.  Suppose if you don't want to reload the old 10 tables and just want to add new table then Partial Reload would be helpful.

This can done by using the ADD attribute to LOAD statement.

Table1:

------

Table2:

--------

Table10:

--------

Table11:

ADD LOAD * INLINE [

    Key1, Value1

    A, 100

    B, 200

    C, 100

];

Now if you use Partial reload, it just reloads the Table11.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Thanks Jagan

That was very useful! Apart from using ADD I have also heard about REPLACE. Can it be used in the Partial Reload? If yes then please tell me how it can be used!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Replace will replace existing data in the table with new data.  This also helps while using Partial Reload. For example

Table1:

------

Table2:

--------

Table10:

--------

Table11:

REPLACE LOAD * INLINE [

    Key1, Value1

    A, 100

    B, 200

    C, 100

];

When we use Partial Load for the above script, first 10 tables are not reloaded, Table11 is replaced with the new data.  I think now you are clear about the REPLACE.

Regards,

Jagan.

Not applicable
Author

Thanks Jagan! That was really helpful!

So can we use only ADD and REPLACE attribute with partial reload? Please correct me if I am wrong...

IAMDV
Luminary Alumni
Luminary Alumni

Thanks Jagan. That was helpful.

At titude - I have created a video post on my blog covering Partial Reload. I hope that helps you as reference to what Jagan mentioned above. Here is the URL : http://qlikshare.com/370

Happy learning!

Cheers - DV

Not applicable
Author

Hi DV,

Thanks a ton! That was really useful.

Thanks,

Attitude

IAMDV
Luminary Alumni
Luminary Alumni

You are welcome mate!

I'm going to post Part - 2 in next 2 days. I'm trying to create atleast scenarios where Partial Reload solves the problem. So please stay tuned.

Cheers - DV

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Nice video, DV.  I didn't know about that use of ONLY...

looking forward to part 2!

Jason

IAMDV
Luminary Alumni
Luminary Alumni

Hi Jason & At titude,

Here is the link for part 2. Sorry for the delay!

http://qlikshare.com/?p=377

Cheers - DV