2 Replies Latest reply: Dec 6, 2017 3:46 PM by Dave Melillo RSS

    Build Mapping Load from SELECT Statement

    Dave Melillo

      I am trying to execute what seems very simple but I am getting a Script Error, Invalid Expression.


      I want to create a mapping load, from the Salesforce User object, containing the Id of the User, and a concatenation of the First and Last name. See below:


      LIB CONNECT TO 'Salesforce_BULK (qlikcloud_qlikid_X)';




      Mapping LOAD


      CONCAT(FirstName,' ',LastName);



      SELECT Id,



      FROM User;