Custom Rule Validation
When configured, custom rule validation checks allow you to define your own boolean validation logic to determine whether a row should be loaded to your destination.
Example
Custom Rule: (fico >= 350 AND fico <= 850) OR fico = 9001 OR fico = 9002 OR fico = 9003 OR fico = 9999
| fico | credit_limit |
|---|---|
| 500 | 2500 |
| 720 | 10000 |
| 9001 | 0 |
| 9002 | 0 |
| 200 | 1500 |
| 9003 | 0 |
| 9999 | 0 |
| 900 | 25000 |
Available Operators
Different operators are available based on the data type of the column being evaluated. The following table shows which operators are available for each Etleap data type:
| Data Type | Equal | Not Equal | In | Not In | Greater Than | Greater Than or Equal | Less Than | Less Than or Equal | Is True | Is False |
|---|---|---|---|---|---|---|---|---|---|---|
| BOOLEAN | ✓ | ✓ | ||||||||
| DATETIME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
| DATE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
| INTEGER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
| JSON | ||||||||||
| NUMBER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
| STRING | ✓ | ✓ | ✓ | ✓ |
Configuration
Key Considerations
- Conditions can be organized into groups, each with independent AND/OR logic, combined under a single top-level operator.
- Only one layer of grouping is allowed (i.e. groups cannot be nested within other groups).
- Custom rules may reference multiple columns in the same row.
- When a row fails the custom rule check, it will throw an error based off of the output column the rule is associated with.