topic Re: Build Mapping Load from SELECT Statement in App Development

Build Mapping Load from SELECT Statement

Anonymous — Wed, 06 Dec 2017 19:44:27 GMT

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;

Re: Build Mapping Load from SELECT Statement

sunny_talwar — Wed, 06 Dec 2017 20:27:38 GMT

Try this

MapUserName:

Mapping

LOAD Id,

FirstName & ' ' &LastName;

SELECT Id,

LastName,

FirstName

FROM User;

Re: Build Mapping Load from SELECT Statement

Anonymous — Wed, 06 Dec 2017 20:46:01 GMT

Thank you as always Sunny