topic Difference between Left Keep and Left Join in QlikView

Difference between Left Keep and Left Join

Fri, 04 Dec 2009 19:13:12 GMT

Hi,

I want to know the clearcut difference between Left Keep and Left Join

Difference between Left Keep and Left Join

Fri, 04 Dec 2009 22:17:04 GMT

I use the left keep to hone down a table to only relevant data to certain field. I am not joining or adding anything to the table, almost like data reduction. See the attachment. Good Luck

Difference between Left Keep and Left Join

Anonymous — Sun, 06 Dec 2009 05:33:50 GMT

In short, if you have two tables and use join, the result is one logical table, but if you use keep, you keep both tables separately.

Re: Difference between Left Keep and Left Join

rohan_mulay — Mon, 12 May 2014 06:57:41 GMT

Consider an example:

Test1:

LOAD * INLINE [

ID,Salary,l1,l2

a,1,1,1

b,2,3,3

c,1,2,2

];

Test2:

Left keep (Test1)

Load * Inline [

ID,F3

a,2

a,3

a,4

b,1

];

Refer the screen shot. Check the explanation in the screen shot below.

Please refer the application for above example and check the result by using left join and left keep.