This transformation adds a prefix and/or a suffix to a designated attribute.
- Choose Task Template: begin by selecting the Add Prefix/Suffix task template.
- Select Attribute: select the attribute that you'd like to add a prefix/suffix to.
- Add prefix: Type the prefix value to add to the attribute you've selected above. This can remain empty if only adding a suffix.
- Add suffix: Type the suffix value to add to the attribute you've selected above. This can remain empty if only adding a prefix.
Example: Add Mr. as a prefix to first names for a designated set of records.
Remember to click Save to save the transformation to your project.