Symptom
- User needs to display text information from different columns in one Calculated Column in Story e.g. need to concatenate First and Last Name but with a space between them
Environment
SAP SuccessFactors People Analytics
Reproducing the Issue
1. Create a New Story query
2. Add a Calculated Column and use CONCAT() function to combine two or more text or string fields
Resolution
The CONCAT() function must be used twice or must be nested.
For example: CONCAT (First Name , CONCAT (" " , Last Name))
This should put a space between the two values. This can apply to any text or string field being combined.
Keywords
concat, concatenante, space, first name, last name, calculated coumn, space between text, space between string , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To