Does KEEP keep the tables seperate but store the results in one table like a join?

[mwallman]

Hello,

I have read numerous posts here and it seems as though KEEP and JOIN functionalities do the same except Keep keeps the tables separate.

But once a Keep function is used, does it store the results in memory in one table but the user still sees it as two separate tables?

[alexandros17]

The result in memory is 2 tables ...

[syukyo_zhu]

keep like where exists(), so you will get 2 tables

[Colin-Albert]

There is an explanation of how the data is stored in Henric Cronmstrom's blog

https://community.qlikview.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-poi...

I can also recommend stephen-x.redmond‌ book Mastering QlikView of you want a more in-depth view of the underlying mechanics of the data store and how to design efficient data models.