You can write transformations in the
Transform area of Studio, using the
Transformation Editor. Transformations can contain
attributes and records from your project data set as variables, and can create
new attributes to hold the transformed values.
The Transformation Editor
You create transformations in the Transformation Editor, this is the built-in Groovy editor within the Transform area in Studio.
Formats for variables
You can use attributes from your project data set as variables in your transformation scripts. This allows you to pass attributes to transform functions as parameters and perform other operations on them.
Setting transformation outputs
You can set your transformation to output to either the selected attribute or a new attribute (this is useful if a transformation is creating a new column).
Functional and dot notation and function chaining
You must use proper syntax when adding transform functions to your script, or your script won't run properly. You can reference all transform functions using functional notation, as described in this topic.