SAP Knowledge Base Article - Public

3441984 - How to add a space to a string type calculated column using CONCAT() - People Analytics Story


  • 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


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


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.


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


SAP SuccessFactors HXM Core 2311