3 Replies Latest reply: May 18, 2018 11:43 AM by Derek Emlet RSS

    Exclude values from table?

    Derek Emlet

      I have been trying multiple ways to exclude demo users from all users -  joining, using where UserID<>USER_ID, etc. I also tried this method below from another post, with no luck. I put the select statements before the loads and it ran, but then the PEOPLE_ID wouldn't return for All_Users.... this is so simple in normal SQL.


      How do I fix this? Thanks.


      Demo_Users:

      LOAD

      USER_ID AS D.USER_ID;

      SELECT

      "USER_ID"

      FROM "DEMO_USERS";

       

      All_Users:

      LOAD

      PEOPLE_ID,

      USER_ID AS A.USER_ID

      WHERE NOT EXISTS(D.USER_ID,A.USER_ID);

      SELECT

      "USER_ID",

      "PEOPLE_ID"

      FROM "All_Users";


      DROP TABLE Demo_Users;