In the data mapper, after you define a mapping, you can transform any field in the mapping. Transforming a data field defines how you want to store the data. For example, you could specify the Capitalize transformation to ensure that the first letter of a data value is uppercase.
-
Map the fields. This can be a one-to-one mapping, a combination mapping, or a separation mapping.
-
In the Mapping Details panel, under Sources or under Targets, in the box for the field that you want to transform, click
to the left of the
trash can icon.
This displays a pull-down where you can select the transformation that you want the data mapper to perform. The set of available transformations is type specific.
-
Click the transformation that you want to perform.
-
Optional. If the transformation requires any input parameters, specify them in the appropriate input fields.
-
Optional. To add another transformation, click the arrow to the left of the trash can icon again.