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

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.

• SAP SuccessFactors HXM HCM Suite
  • Integration Center

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.

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;
   1. 
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.
   1. 

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

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