range

This rule validates the value of the specified field against a numeric range. The range is specified in integers. When used alone with the Data Cleanser, this rule rejects records containing field values that fall outside of the given range. You can also use this rule with conditional rules and operators to define more complex rules. When this rule is used with the Data Profiler, the frequency report includes a frequency of field values that fall within the range.

The syntax for range is:

<range fieldName="name" min="minimum" max="maximum"/>

The parameters for range are:

• fieldName – The qualified field name or assigned variable for the field to validate.

• min – An integer indicating the minimum value in the numeric range.

• max – An integer indicating the maximum value in the numeric range.

Example 8 Sample range Rule

This sample validates United States postal codes to be sure they fall within a valid range. Records containing postal codes less than 06000 or greater than 99950 will be rejected or will not be included in a frequency report. Note that the PostalCode field needs to be a numeric data type in order for this to be a valid rule.

<rule>
  <range fieldName="Person.Age" min="06000" max="99950"/>
</rule>