# Introduction to the Required Values Check

Source: https://userguide.qualytics.io/data-quality-checks/required-values/introduction/

*Requires the Data Quality (DQ) module.*

The Required Values check asserts that every value on a list actually shows up in a column at least once. It is the completeness rule for reference data: it does not care what else the column holds, only that nothing on your list went missing.

This section is the complete guide to the check. The Deep Dive covers the definition, properties, and full evaluation semantics, explains how anomalies are reported, walks through production examples, and collects best practices; the How-tos are step-by-step tutorials for creating, editing, and deleting a check; the API page documents the payload for programmatic use; and the FAQ answers the most frequent questions.

## Next Steps

- **How It Works**

  The complete reference: definition, field scope, the value list, how it differs from Expected Values, the distinct-value limit, and why coverage does not apply.

  [How It Works](https://userguide.qualytics.io/data-quality-checks/required-values/deep-dive/how-it-works/)
- **Anomaly Reporting**

  The Shape Anomaly the check produces, what it reports, and why there are no source records to inspect.

  [Anomaly Reporting](https://userguide.qualytics.io/data-quality-checks/required-values/deep-dive/anomaly-reporting/)
- **Examples**

  Three production scenarios with sample data, the resulting anomaly, and the SQL equivalent of what the check evaluates.

  [Examples](https://userguide.qualytics.io/data-quality-checks/required-values/deep-dive/examples/)
- **Best Practices**

  Guidelines for choosing the list, scoping with a filter, and pairing the rule with Expected Values.

  [Best Practices](https://userguide.qualytics.io/data-quality-checks/required-values/deep-dive/best-practices/)
- **Permissions**

  The team permission each action needs: view, create, edit, archive, restore, and delete.

  [Permissions](https://userguide.qualytics.io/data-quality-checks/required-values/deep-dive/permissions/)
- **Create a Check**

  Step-by-step tutorial for creating a Required Values check on a field.

  [Create a Check](https://userguide.qualytics.io/data-quality-checks/required-values/how-tos/create-a-check/)
- **Edit a Check**

  Step-by-step tutorial for changing the value list or the filter on an existing check.

  [Edit a Check](https://userguide.qualytics.io/data-quality-checks/required-values/how-tos/edit-a-check/)
- **Delete a Check**

  Step-by-step tutorial for archiving a check and deleting it permanently.

  [Delete a Check](https://userguide.qualytics.io/data-quality-checks/required-values/how-tos/delete-a-check/)
- **Troubleshooting**

  Common problems with whitespace, casing, high-cardinality columns, filters, and aggregate anomaly reporting.

  [Troubleshooting](https://userguide.qualytics.io/data-quality-checks/required-values/troubleshooting/)
- **API**

  Payload shape and field notes for creating a Required Values check programmatically.

  [API](https://userguide.qualytics.io/data-quality-checks/required-values/api/)
- **FAQ**

  Short answers to questions about the value list, how the rule differs from Expected Values, and anomaly reporting.

  [FAQ](https://userguide.qualytics.io/data-quality-checks/required-values/faq/)

*Last updated: October 19, 2026.*
