Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Try this
MapUserName:
Mapping
LOAD Id,
FirstName & ' ' &LastName;
SELECT Id,
LastName,
FirstName
FROM User;
Try this
MapUserName:
Mapping
LOAD Id,
FirstName & ' ' &LastName;
SELECT Id,
LastName,
FirstName
FROM User;
Thank you as always Sunny