Range Check Rule

Description

A Range Check rule is used to verify that the values in a data set fall within a specified valid range. It ensures that data values are not outside a defined minimum (start range) or maximum (end range) threshold.

Rule Configuration

The Rules Configuration for a Range check rule are based on whether the data falls within the defined start and end range. The data is considered valid if it is greater than or equal to the start range (minimum) and less than or equal to the end range (maximum). Any value outside this range, either below the start range or above the end range, is deemed invalid.

• Start Range The minimum valid value that data can have. Any value below this threshold is considered invalid.
• End Range The maximum valid value that data can have. Any value above this threshold is considered invalid.

Success Criteria

The success criterion for Range Check rule is met when the input value falls within the predefined valid range.

• The success condition depends on how the Start range and End range are configured.

• The success condition is met if this count satisfies the given operator and value.

• For example,If Start-range is set to 10and End Range is set to 50 any number in column between 10 and 50 are considered invalid.

  Configuration Fields

  • Operator Options

    • Greater than
    • Less than
    • Equal to
    • Between (requires specifying a start and end range)

  • Operator Defines the comparison operation (Greater Than, Less Than, Equal To, or Between).

  • Value The threshold value used for success criteria. Required for Greater than, Less than, and Equal to operators.

  • Value Range Required only when the Between operator is selected, specifying the start and end range.

  • Threshold Type Indicates whether the Value or Value Range to be considered as percentage or an absolute count.

  • Allow Null Values Determines if null values are permitted.

Sample Input

ID	Value	Date
1	8	2025-01-09
2	15	2024-10-29
3	25	2025-01-28
4	45	2025-01-23
5	55	2025- 02-06
6	65	2024-12-31
7	75	2025-02-03

Sample Rule Configuration

• Start Range Value = 10 Date = 2025-01-01
• End Range Value = 50 Date = 2025-02-04

Sample Success Criteria Configuration

• Operator Greater than
• Value 3
• Threshold Type Absolute Count
• Allow Null Values True

Sample Output

Column Name	Rule Name	Success Count	Failure Count	Within Threshold
Value	Value Range Check	3	4	No
Date	Range Check	4	3	Yes