topic Doubt in QlikView

Doubt

NavinReddy — Tue, 24 Dec 2013 08:59:06 GMT

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

tresB — Tue, 24 Dec 2013 09:03:29 GMT

Anonymous — Tue, 24 Dec 2013 09:06:32 GMT

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 — Tue, 24 Dec 2013 09:13:31 GMT

Hi Anant,

Thanks for your replay,

Regards,

Niranjan

hic — Fri, 17 Jan 2014 16:41:14 GMT

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

HIC