Use the Discretize Clean Transformer - Define rules window to select data column values that are in a range between two specified bounds, and update the values with a replacement value in the target column. You can use character string or numeric data types. The comparison is performed in the locale specific order for the character set that you are using.
To define rules for the Discretize clean type:
Select a rules table from the Rules table list.
Select a column in the rules table that contains lower bound values to search for. In the Available columns list, select a column, then click > next to the Lower bound column field.
Select a column in the rules table that contains upper bound values to search for. In the Available columns list, select a column, then click > next to the Upper bound column field.
Select a column in the rules table that contains a replacement value. In the Available columns list, select a column, then click > next to the Replacement value column field.
Optional: Select a column that contains the sequence in which to read rows in the rules table. Click a column in the Available columns list, then click the > button that is next to the Order by column field. The column that you select should be of type Integer.
Click OK to save your changes and close the window.