What is meant by partial reload? What is its use? ... - Qlik Community

Report Inappropriate Content · ‎2012-02-29

Hi All,

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

Thanks,

Attitude

jagan · ‎2012-03-01

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.

Report Inappropriate Content · ‎2012-03-01

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 · ‎2012-03-02

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.

Report Inappropriate Content · ‎2012-03-13

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 · ‎2012-04-24

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

Report Inappropriate Content · ‎2012-04-24

Hi DV,

Thanks a ton! That was really useful.

Thanks,

Attitude

IAMDV · ‎2012-04-24

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 · ‎2012-04-24

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

looking forward to part 2!

Jason

IAMDV · ‎2012-04-29

Hi Jason & At titude,

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

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

Cheers - DV