Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm trying to perform something like a LEFT JOIN WHERE between 2 tables in order to get the values that are exclusive for the first table.
What I have is like:
TableX:
LOAD A, B Resident TableA;
Left Join (TableX)
LOAD A Resident TableA where IsNull(A);
It looks like the where clause is not working properly and I'm still getting values from TableB. Any help or idea?
Thanks!
One way.
TableY:
Load A
Resident TableB;
noconcatenate
TableX:
Load A
Resident TableA
where not exists(A);
Drop TableY;
Thanks for your comments, but it looks like it did not work. On that way, TableX is created without any value.
Also, I can´t see the relation between TableX and TableY based on your example (sorry, I'm sooo new on this).