Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to know the clearcut difference between Left Keep and Left Join
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.
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
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.
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.