Doubt

[NavinReddy]

Hi All,

i have one doubt in using join and keep

when i have two tables join will make it one table,

when i have two tables keep will make it as it is,

in data model keep will give bad performance ,Then why we are preferring Keep  instated on join,and usage of keep

Please some one explain me

Thanks In Advance

Niranjan

[tresesco]

See here : Joins and Lookups

[Anonymous]

un appropiate use of joins may leed to duplication of rows in case of joins

and that often happens but keep the left or right tables as also  maintaing the join condition and

filtering of rows accordind to inner,outer,left , right join in most scenarios keep do not duplicate data

or corrupt data but this happens but nothing like join is worst and keep is best it is just that there in appropiate

use leeds to error.

anant

[NavinReddy]

Hi Anant,

Thanks for your replay,

Regards,

Niranjan

[hic]

"Keep" will not per se give bad performance. It is the most efficient way to remove unwanted records.

And your data model should in most cases contain several tables. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

HIC