23 Replies Latest reply: Oct 12, 2017 9:32 AM by Sunny Talwar RSS

    Restrict LOAD to IDs in Resident Table

    Dave Melillo

      In my Qlik Sense app, I am FIRST loading a list campaign members from one campaign in salesforce.

       

      I want to load ONLY lead/contact information from people who are a part of that campaign.

       

      I would imagine the syntax to be something like below, but I know this is not correct:

       

      LOAD

      @1,

      @2,

      @3;

       

      SELECT * FROM Lead

      WHERE Id IN (SELECT DISTINCT Id FROM ResidentTable)

       

      Any help is appreciated!