Validation Rule: Value range evaluation

back to DataCleaner | back to DataCleanerUserGuide

The Value range evaluation validation rule evaluates whether or not values are in a specified value range. The rule requires at least one of the two configuration parameters to be set.

• Highest value ~ The highest value allowed in the range.
• Lowest value ~ The lowest value allowed in the range.

Entered values will be sought converted to a fitting type, so that date/time based columns will compare values based on chronology, numbers will compare based on number-values and literals will compare based on string comparison.

Note: It is possible to only define either highest value or lowest value. If you do so then only the high/low limit will be evaluated.