Use the Clip clean type to find numeric data column values that are less than or greater than specified values, and update the target column with corresponding replacement values.
You can use the Clip clean type for numeric data types only.
To avoid lower or upper bound clipping, specify the database null value in the rules table. The database null value can also be used as the replacement value.
To define the rules for the Clip clean type:
Select a rules table from the Rules table list.
Select a column from the rules table that contains the lower bound values to search for. Click a column in the Available columns list, then click > next to the Lower bound column field.
Select a column from the rules table that contains the upper bound values to search for. Click a column in the Available columns list, then click > next to the Upper bound column field.
Select a column from the rules table that contains the lower bound replacement values. Click a column in the Available columns list, then click > next to the Lower replace value column field.
Select a column from the rules table that contains the upper bound replacement values. Click a column in the Available columns list, then click > next to the Upper replace 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, the 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.