Value Range Validation

A Value Range Validation is used to verify that the values in a dataset 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 Value Range Validation is 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 considered invalid.

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

Success criteria

The success criterion for a Value Range Validation 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 the count satisfies the given Operator and Value.
For example, if the Start range is set to 10 and the End range is set to 50, any number in the column between 10 and 50 is considered valid.

Configuration fields

Operator options

Greater than

Less than

Equal to

Between (requires specifying a start and end range)
Operator defines the comparison operation. You can choose from Greater Than, Less Than, Equal To, or Between.
Value is the threshold value used for the success criteria. It is required for Greater than, Less than, and Equal to operators.
Value range is required only when the Between operator is selected. It specifies the Start and End range.
Threshold type indicates whether the Value or Value Range is to be considered as a percentage or an absolute count.
Allow null values determines if null values are permitted.
Check for match determines if data values align with predefined standards, formats, or reference values to ensure accuracy, consistency, and integrity.

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
Check for Match False

alt text

Sample Output

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