Difference between Left Keep and Left Join

[#1]

Hi,

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

[#2]

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

[Anonymous · Accepted solution]

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.

[rohan_mulay]

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.