---
title: Not Null Check
description: Validates that specified columns contain no null values.
group: Completeness
---

# Not Null Check

The **Not Null Check** rule verifies that specified columns contain the required number of non-null values.  
This rule is commonly used to:

- Ensure mandatory fields like customer names or product prices are populated  
- Validate data completeness in critical reporting fields  
- Detect missing values in essential business columns  

**Example Usage**:  
- Confirm that all customer records have `Email` addresses  
- Check that at least 95% of `ProductCode` entries are not null  

## Configuration Fields  

---

### 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 non-null value count               | Yes        | `GreaterThan`, `LessThan`, `EqualTo`, `Between`                      |
| **Threshold Value** | Value for comparison (single value for most operators)      | 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 of total rows | No         | `true` / `false` (default: `false`)                                  |

---

## Sample Input Data  

| ID | Name    | Age  | Email               |
|:----|:---------|:------|:---------------------|
| 1  | Alice   | 25   | alice@example.com   |
| 2  | Bob     | 30   | bob@example.com     |
| 3  | Charlie | NULL | charlie@example.com |
| 4  | David   | NULL | NULL                |
| 5  | NULL    | NULL | erin@example.com    |

---

## Sample Configurations  

### Example 1: Absolute Count Check  



| Configuration Field | Value       |
|:---------------------|:-------------|
| Column                | Name        |
| Operator              | EqualTo     |
| Threshold Value       | 4           |
| Is Percentage         | false       |

**Explanation**:  
Validates that exactly 4 `Name` values are non-null.

---

### Example 2: Percentage Range Check  




| Configuration Field | Value       |
|:---------------------|:-------------|
| Column                | Email       |
| Operator              | Between     |
| Threshold Min         | 70          |
| Threshold Max         | 100         |
| Is Percentage         | true        |

**Explanation**:  
Validates that between 70% and 100% of `Email` values are non-null.

---

## Sample Output  

| Column Name | Rule Name       | Success Count | Failure Count | Within Threshold |
|:-------------|:------------------|:---------------|:---------------|:------------------|
| Name        | Not Null Check     | 4             | 1             | Yes              |
| Age         | Not Null Check     | 2             | 3             | No               |
| Email       | Not Null Check     | 3             | 2             | No               |

---