Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Confunsion in keep function.
Hey,
Check this out.
Understanding Join, Keep and Concatenate
Difference between left Keep vs left Join
BR,
Chinna
Hi,
TableA:
ID, Value1
1, One
2, Two
TableB:
ID, Value2
1, Test1
3, Test3
4, Test4
In Left Join: TableA & TableB resultant table
JoinTable:
ID, Value1, Value2
1, One, Test1
2, Two, Null
In Left Keep: Both tables will be separate both are not joined physically just join logic is applied
TableA:
ID, Value1
1, One
2, Two
Left Keep(TableA)
TableB:
ID, Value2
1, Test1
Hope this helps you.
Regards,
Jagan.