Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dmelillo
Contributor II

Build Mapping Load from SELECT Statement

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;

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Build Mapping Load from SELECT Statement

Try this

MapUserName:

Mapping

LOAD Id,

     FirstName & ' ' &LastName;

SELECT Id,

     LastName,

     FirstName

FROM User;

2 Replies
MVP
MVP

Re: Build Mapping Load from SELECT Statement

Try this

MapUserName:

Mapping

LOAD Id,

     FirstName & ' ' &LastName;

SELECT Id,

     LastName,

     FirstName

FROM User;

dmelillo
Contributor II

Re: Build Mapping Load from SELECT Statement

Thank you as always Sunny