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).

Applying a transformation to the selected attribute overwrites the attribute with the transformed data. Setting the transformation to output to a new column adds a new attribute to your project data set.

To set the output for a transformation:

  1. Select one of the radio buttons next to the Transformation Editor:
    • Apply transformation to [attribute name]
    • Create a New Attribute
  2. If you selected Create a New Attribute, enter a unique name for the new attribute in the New Attribute Name text box.
    The new name can only contain alphanumeric characters and underscores (_). If the name you enter contains unsupported characters, the outline of the text box turns red and you receive an error message if you try to preview or save the transformation.
  3. Optionally, select the new attribute's data type from the Data Type dropdown menu.
    Transform automatically selects an appropriate data type, but you can override its choice.
  4. If the new attribute should be multi-assign, deselect the Single Assign checkbox.