The Consistent Casing rule ensures text data is consistently formatted according to a specified casing standard within a dataset.
This rule is commonly used to:
- Standardize names, labels, or codes to a defined casing convention.
- Prevent issues in downstream processes caused by inconsistent text formatting.
Example Usage:
Check that all customer names follow Pascal Case (e.g., JohnDoe, JaneSmith) and country codes follow snake_case (e.g., united_states, great_britain).
Configuration Fields
Rule-Specific Configuration
| Field Name | Description | Required | Data Type / Options |
|---|
| Case Type | Casing format to validate against | Yes | Upper Case, Lower Case, Title Case, Sentence Case, camelCase, PascalCase, kebab-case, snake_case |
Success Criteria Configuration
This section defines how the rule’s outcome is measured against expected thresholds.
| Field Name | Description | Required | Options / Format |
|---|
| Operator | Comparison operation for the result count | Yes | GreaterThan, LessThan, EqualTo, Between |
| Threshold Value | Value for comparison (for GreaterThan, LessThan, EqualTo) | Conditional | Number |
| Threshold Min | Minimum value (for Between operator) | Conditional | Number |
| Threshold Max | Maximum value (for Between operator) | Conditional | Number |
| Is Percentage | Whether the threshold represents a percentage or an absolute count | No | true / false (default: false) |
| Allow Nulls | Whether null values are considered valid | No | true / false (default: false) |
| Check For Match | When false, validates for negation of the condition | No | true / false (default: true) |
| ID | Customer | Country |
|---|
| 1 | Fallon | greatBritain |
| 2 | FranklynFryer | France |
| 3 | Kathleen | unitedStates |
| 4 | JudieGreen | |
| 5 | JohnDoe | France |
Sample Configurations
Example 1: Customer Name Pascal Case Check
| Configuration Field | Value |
|---|
| Column | Customer |
| Case Type | PascalCase |
| Operator | GreaterThan |
| Threshold Value | 75 |
| Is Percentage | true |
| Allow Nulls | false |
| Check For Match | true |
Explanation:
Validates that at least 75% of customer names are in PascalCase.
Example 2: Country Lower Case Check
| Configuration Field | Value |
|---|
| Column | Country |
| Case Type | Lower Case |
| Operator | GreaterThan |
| Threshold Value | 60 |
| Is Percentage | true |
| Allow Nulls | false |
| Check For Match | true |
Explanation:
Validates that at least 60% of country names are in lower case.
Sample Output
| Column Name | Rule Name | Success Count | Failure Count | Null Count | Within Threshold |
|---|
| Customer | Consistent Casing | 5 | 0 | 0 | Yes |
| Country | Consistent Casing | 2 | 3 | 1 | No |
