Home > Transforms Nodes > Filter Columns > Transform > Edit Transform Node
Use this dialog to define or edit the Transform node.
The default is to show statistics for each column. If you do not want to see statistics, deselect Show Statistics.
You must run the node to see statistics.
You can either add a transformation or you can define a custom transformation:
To define a transformation, select one or more original columns (columns that are not transformed) and click
The Add Transform dialog opens if you selected one or fewer columns; otherwise, the Apply Transform Wizard opens.
To define a custom transform, select one or more original columns (columns that are not transformed) and click
The Add Transform dialog opens so the you can Add Custom Transform.
The default behavior to ignore the original column and to use the transformed column as output. The value displayed in the Output column is
for a column that is included and
for a column that is ignored.
For example, if you bin AGE creating AGE_BIN, then AGE is not passed on and AGE_BIN is passed on.
You can changed the value in the Output Column by clicking the icon displayed in the Output column.
To see the effects of a transform, run the node. After the node completes, double-click the node. Select the transformed column to see histograms that compared the original column with the transformed column.
You can edit transformed columns only. For example, you can edit AGE_BIN, but not AGE. To edit transforms, select one or more transformed columns and click
The Edit Transform dialog opens if you selected one or fewer columns.
To delete transforms, select one or more transformed columns and click
To filter columns (limit the number of columns displayed), use
You can search by Output Column (the default), Transform, or Source Column. To clear the filter definition, click