A transformation type Prefix-Suffix will transform data from the incoming file by adding characters to the beginning (prefix) and/or to the end (suffix) of a string.
To configure a prefix-suffix transformation:
- Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
- Use the Transformation type list to select Prefix-Suffix.
- Enter values in the Prefix and Suffix fields. You have the option of using both fields or only one of them.
- Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
- Click Apply.