Join tables in order to get values that are just in the first one

[Anonymous]

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!

[Anonymous]

One way.

TableY:

Load A

Resident TableB;

noconcatenate

TableX:

Load A

Resident TableA

where not exists(A);

Drop TableY;

[Anonymous]

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).