Simple transforms such as splitting attributes, trimming attributes, or changing the case of attributes are listed on the Basic tab of the Transform page.
Splitting String attribute values
The Split transformation creates one or more new attributes from the original value. You can only split String attributes.
Selecting subsets of date/time values
For date/time attributes, you can truncate the date/time values to only include a specific subset of the date/time units.
Changing the capitalization of String values
When you change the capitalization, the transformation is immediately added to the transformation script. There is no configuration, and the change always overwrites the selected attribute.
Performing mathematical operations on numeric values
For numeric attributes, you can perform mathematical operations. The available operations change based on whether the attribute you select is an integer, long, or double value.