Discussion board where members can get started with Qlik Sense.
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?
where not exists(A);
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).