The Predefined Value Check rule validates that column values match one of a predefined set of static values. It ensures consistency, accuracy, and integrity in data by restricting entries to only valid, accepted values.
Example Usage:
Check that product categories only include allowed values like Electronics, Furniture, Apparel, or that country codes match predefined ISO codes.
Configuration Fields
| Field Name | Description | Required | Data Type |
|---|
| Static Values | Array of allowed values to validate against | Yes | string[] |
| Case Sensitive | Whether matching should consider letter casing | No | Boolean |
Success Criteria Configuration
| Field Name | Description | Required | Options | Default |
|---|
| Operator | Comparison operation for match count | Yes | GreaterThan, LessThan, EqualTo, Between | - |
| Threshold Value | Single comparison value (for non-Between operators) | Conditional | Number | - |
| Threshold Min | Minimum value for Between operator | Conditional | Number | - |
| Threshold Max | Maximum value for Between operator | Conditional | Number | - |
| Is Percentage | Whether threshold represents percentage of total rows | No | true/false | false |
| Allow Nulls | Whether null values should be treated as valid | No | true/false | false |
| Check For Match | When false, validates for negation of the condition | No | true/false | true |
| ID | Vegetables | Fruits |
|---|
| 1 | Tomato | Pineapple |
| 2 | Lettuce | apple |
| 3 | Carrot | Mango |
| 4 | Onion | Apple |
| 5 | broccoli | Banana |
Sample Configurations
Example 1: Vegetables Column Check
| Configuration Field | Value |
|---|
| Static Values | ["Tomato", "Onion", "Broccoli"] |
| Case Sensitive | true |
| Operator | LessThan |
| Threshold Value | 4 |
| Is Percentage | false |
| Allow Nulls | false |
| Check For Match | false |
Explanation:
Validates that fewer than 4 Vegetables entries match the predefined values exactly (case-sensitive).
Example 2: Fruits Column Check
| Configuration Field | Value |
|---|
| Static Values | ["Apple", "Banana", "Mango", "Pineapple"] |
| Case Sensitive | true |
| Operator | LessThan |
| Threshold Value | 4 |
| Is Percentage | false |
| Allow Nulls | false |
| Check For Match | false |
Explanation:
Validates that fewer than 4 Fruits values match the predefined static values exactly.
Sample Output
| Column Name | Rule Name | Success Count | Failure Count | Null Count | Within Threshold |
|---|
| Vegetables | Predefined Value Check | 2 | 3 | 0 | Yes |
| Fruits | Predefined Value Check | 4 | 1 | 0 | No |
