Preceding Vs Resident Load

[vanderson009]

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

[dplr-rn]

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

[vanderson009]

Could you please explain with scenario.

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

[dplr-rn]

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]

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