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

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

    Jose Ignacio 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:

       

      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!