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)';

       

       

      MapUserName:

      Mapping LOAD

      Id,

      CONCAT(FirstName,' ',LastName);

       

       

      SELECT Id,

      LastName,

      FirstName

      FROM User;