Specifying a numeric tolerance for your Clean Data transformer

Use the Numeric Parameter window to specify a numeric tolerance for your transformation. A numeric tolerance is a number that you apply to numeric find values. The numeric tolerance allows the replacement of a value that is just outside a find value or a range of find values.

For example, you use the Discretize clean type to replace the find value numeric ranges in the following manner:

23.50 -24.50 replaced by 1000

If you specify a tolerance of 0.10, then input data of 23.40 and 24.60 would also be replaced by 1000 in the example above.

The default value is 0.0.

../rule.gif

To specify a numeric tolerance for your Clean Data transformer:

  1. In the Numeric tolerance field, type a numeric tolerance.

  2. Optional: If you do not want the Clean Data transformer to copy a value if it matches a column in the rule table, select the Do not copy record to output if rule match is found check box.

  3. Click OK to save your changes and close the window.