This content has been marked as final. Show 2 replies
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:
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?