Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Tags (2)
22 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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

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

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!

MVP & Luminary
MVP & Luminary

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

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

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

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...

Luminary
Luminary

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

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

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

Hi DV,

Thanks a ton! That was really useful.

Thanks,

Attitude

Luminary
Luminary

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

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_michaelid
Honored Contributor II

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

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

looking forward to part 2!

Jason

Luminary
Luminary

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

Hi Jason & At titude,

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

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

Cheers - DV