Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vanderson009
Contributor III

Preceding Vs Resident Load

Hi

Can someone explain exact difference between preceding and resident load with example.

Like in which scenario we should use resident and in which preceding.

Thanks,

Villyee

4 Replies
Partner
Partner

Re: Preceding Vs Resident Load

they are similar in that you loading data you have in memory once more but preceding load is in most cases faster.
check below
https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

also the code is much cleaner.

so basically use preceding load when you can.

note- there are other uses for resident load e.g. you load your table but you want a subset (columns/rows) in another table
Highlighted
vanderson009
Contributor III

Re: Preceding Vs Resident Load

Could you please explain with scenario.

It means in which scenario we should use resident but not preceding.
Partner
Partner

Re: Preceding Vs Resident Load

you are loading table A with 5 columns. you want to check the value of a column and add flags as new columns.
you should use preceding load.

as i mentioned before
resident load e.g. you load your table but you want a subset (columns/rows) in another table
Armyer8345
New Contributor

Re: Preceding Vs Resident Load

Hi,

Preceding load faster than Resident load.

Go through Henric's Blog pos and commentss..

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load/TTRockStars