SAP Knowledge Base Article - Public

2892300 - How to add a value between two fields in Calculated field in Integration Center

Symptom

How to create a field which adds (concatenates) the values of two or more fields using a calculated field?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

 SAP SuccessFactors HXM Suite

Resolution

This can be done through adding a calculated field in Integration center.

Let's say the business requirement is to combine two fields  "Pay Scale Group" and "User ID"  in one field and add a value between the mentioned fields.

Example value:

Payscale Group value: USA/PROD/PLANT/ASSEMBLY

Userid: 100258

Required result:

USA/PROD/PLANT/ASSEMBLY00000100258

The logic is as follows:

    1. Field Value = [Pay Scale Group (payScaleGroup) from Empjob]
    2. Concatenate/Append "00000000"
    3. Concatenate/Append [User ID (userId) from Empjob]

kbaconcatenate.PNG

 

What this did was to combine the PayscaleGroup field + added the string 0000 + userID field.

NOTE: It is not possible to concatenate/append values of a single field from different rows (starting records). It is only possible to concatenate values from different fields corresponding to the same row (starting record).

See Also

 2597306 - How to Add Leading Zeros to a String Field to bring the employees User ID username up to a required length

Keywords

Add string between two fields, How-To , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HXM Suite all versions