SAP Knowledge Base Article - Public

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

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

Product

SAP SuccessFactors HXM Core 2311