SAP Knowledge Base Article - Public

2930169 - Split Data in Integration Center - SAP SuccessFactors HXM Suite

Symptom

You want to split a string field in two different columns in Integration Center. 

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 HCM Suite
    • Integration Center

Reproducing the Issue

  1. Access Integration Center
  2. Click on "My Integrations"
  3. + Create > Scheduled Simple File Output Integration
  4. Select your Start Entity and the required fields. 

To use as an example, we chose User entity to separate the Customizable Field 9 in two different columns.

Resolution

You have to use calculated field to get the needed results.

Reproduce the bellow steps:

  1. Add a Calculated Field;
  2. Select Field Value;
  3. Choose the field you want;
  4. Select truncate from left;
  5. Set the number of characters to preserve from the left side and click OK;
  6. Add a new Calculated Field;
  7. Choose the same field;
  8. Select Substring to extract the specific portion of the string;
  9. Set the start position and the number of character to include from the start.

In the end, you should have an integration with the needed data as the image below:

Keywords

Integration Center, Calculated Field, Split, Substring, SAP SuccessFactors HXM HCM Suite , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions

Attachments

Pasted image.png