SAP Knowledge Base Article - Public

2678297 - Integration Center: Usage of the 'Replace' operation in Calculated Fields / Filters / Filenames

Symptom

This document has been created to provide a demonstration of the 'Replace' functionality in Integration Center's Calculated Field / Filter / Filename functionalities / features

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

Environment

  • SuccessFactors BizX
  • Integration Center

Reproducing the Issue

  1. Create an integration in Integration Center

  2. Extract data from SuccessFactors / Input data from external source (e.g. .csv file on SFTP) (i.e. Outbound Inbound Jobs)
    1. Extract the desired data from SuccessFactors to meet your output requirements (Outbound Job)
    2. Input the desired data to SuccessFactors to meet your input requirements (Inbound Job)

  3. You observe that some of the field data does not meet your input / output requirements (e.g. format / content of field / filter / filename must be altered)

Cause

The cause of such issues is usually the way in which data is maintained within different systems

Resolution

Below you will find 3 examples highlighting the usage of the Replace operation in Integration Center's Calculated Fields / Filters / Filenames  features

(in both Outbound & Inbound integrations)

 

We use the square brackets [ ] to isolate the value which we would like to alter / replace

Once isolated, we input the required change in the 'Text To Insert' input box to  alter / replace the isolated value

 

The below example shows the usage of 'Replace' in a Calculated Field of an outbound integration:

Requirement: Change delimiter / separator in FTE value stored in job_information (EmpJob) from '.' to ','

Inbound_Outbound_EG.png

 

This operation can also be used in Calculated Filter and Calculated Filename functionalities (use-cases may vary)

Keywords

FTE, Comma, Delimit, Period, Integration Center, Replace, Calculated Field, Calculated Filter, Calculated Filename , KBA , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HXM Suite all versions