Field Mapping Transformations
Field Mapping Transformations allow you to apply data transformations using the Expression Wizard, including operations like Constants, Value Mapping, Conditional Mapping, String to Date, and Negate Decimal.
Data transformations can be applied using the Expression Wizard. The Expression Wizard is accessed by clicking the cog icon between the Source and Target fields.
Constants
Constants are used when there is no available source field for a mapping. This transformation allows a fixed value to be sent to the target system.
After selecting the Constant operation, enter the desired value and click Submit.
Constants are sent to the target system as string values.
Value Mapping
Value Mapping allows the target value to change depending on the value of a source field. After selecting Value Mapping, you must choose a source field and define a condition. Supported conditions include:
Is equal to
Is in
Is not equal to
Is not in
Is not null
If the source field meets the specified condition, the value defined in the THEN section is sent to the target system.
You must complete all required fields and click Submit to save the configuration.
Conditional Mapping
Conditional Mapping allows you to dynamically transform data during synchronization. First, select the source field. Then define the expected data type of the source value and the data type to send to the target system. You can then specify the evaluation condition and define the values to send when the condition is met or not met.
Example:
When Currency == EUR, send "EURO", otherwise send "INELIGIBLE CURRENCY CODE".String to Date
The String to Date transformation converts a string field into a Date data type.
To use this transformation, select String to Date, choose the source field, and click Submit.
Negate Decimal
The Negate Decimal transformation reverses the sign of a decimal value. This is commonly used when the source system reports values differently from the format required by the target system.
Example: Zuora reports discount amounts as positive values, but SAP requires them to be submitted as negative values.