Home > Transforms Nodes > Filter Columns > Transform > Edit Transform Node > Add Transform > Add or Edit Multiple Transf...
You can define or edit transforms for several column at a time; you can also apply an existing transformation to one or more columns.
One difference between defining a transform for one column and several columns is that statistics are not displayed.
Follow these steps to add or edit transforms for multiple transforms:
Double-click the transform node. The Transformation Editor opens.
To define the same transform for several columns, select the columns. You can select columns with different data types. If there are no transform that apply to all columns, you get a message. Click
The Apply Transform Wizard launches. Select the transform to apply to all columns. Specify details, such as number of bins. Click Next. You can change the names of the output columns. Select Generate Statistics on Finish if you wish. Click Finish.
If you have already transformed a column, you can define the same transformation for several other columns.
Suppose that you have binned AGE creating AGE_BIN. To bin several columns in the same way, select AGE and the columns that you want to bin in the same way. Click
The Apply Transform Wizard launches. Select <Use Existing> for Transform Type. AGE_BIN is listed as the Transformed column. You cannot change any other values. Click Next. You can change the names of the output columns. Select Generate Statistics on Finish if you wish. Click Finish.
To edit several transformations at the same time, select the transformations and click
The Apply Transform Wizard launches. Edit the transforms and click Finish.