Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Partial reload function

Hej Guys,

I'm currently working on a datamodel large datasets with multiple facttable. I want to reduce the development speed with partial load function in combination with the Replace / Add statement into the script. Does anyone has experience with this and what's the best practice (whitepapers, blogs..) for using Partial reloads.

Any suggestions?

Robert

1 Reply
Highlighted
Master III
Master III

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.