Build Mapping Load from SELECT Statement

[Anonymous]

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;

[sunny_talwar · Accepted solution]

Try this

MapUserName:

Mapping

LOAD Id,

     FirstName & ' ' &LastName;

SELECT Id,

     LastName,

     FirstName

FROM User;

[Anonymous]

Thank you as always Sunny