2 Replies Latest reply: May 18, 2017 5:14 PM by Jose Teglia RSS

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

    Jose Teglia

      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?