topic Re: Preceding Vs Resident Load in QlikView

Preceding Vs Resident Load

vanderson009 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Preceding Vs Resident Load

dplr-rn — Thu, 04 Apr 2019 18:27:49 GMT

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

Re: Preceding Vs Resident Load

vanderson009 — Fri, 05 Apr 2019 17:08:20 GMT

Could you please explain with scenario.

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

Re: Preceding Vs Resident Load

dplr-rn — Fri, 05 Apr 2019 17:13:30 GMT

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

Re: Preceding Vs Resident Load

Armyer8345 — Tue, 09 Apr 2019 04:15:34 GMT

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