# Introduction to the Equal To Field Check

Source: https://userguide.qualytics.io/data-quality-checks/equal-to-field/introduction/

*Requires the Data Quality (DQ) module.*

The Equal To Field check asserts that two columns on the same row hold the same value. Unlike a constant, the reference moves with the data, so the rule keeps meaning the right thing as the values change. Use it to keep a denormalized copy in step with its source, or to confirm two systems wrote the same figure.

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 compared field, the three comparators, NULL handling, filter behavior, and coverage.

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

  The anomaly messages the check produces, what the numbers mean, Source Records highlighting, and Custom Anomaly Description.

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

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

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

  Guidelines for choosing the reference field, setting tolerances, and deciding between this rule and its alternatives.

  [Best Practices](https://userguide.qualytics.io/data-quality-checks/equal-to-field/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/equal-to-field/deep-dive/permissions/)
- **Create a Check**

  Step-by-step tutorial for creating an Equal To Field check between two columns.

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

  Step-by-step tutorial for changing the compared field or adjusting the comparators.

  [Edit a Check](https://userguide.qualytics.io/data-quality-checks/equal-to-field/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/equal-to-field/how-tos/delete-a-check/)
- **Troubleshooting**

  Common problems with NULLs, type mismatches, formatting noise, and anomaly reporting.

  [Troubleshooting](https://userguide.qualytics.io/data-quality-checks/equal-to-field/troubleshooting/)
- **API**

  Payload shape and field notes for creating an Equal To Field check programmatically.

  [API](https://userguide.qualytics.io/data-quality-checks/equal-to-field/api/)
- **FAQ**

  Short answers to questions about the compared field, comparators, NULLs, and anomaly reporting.

  [FAQ](https://userguide.qualytics.io/data-quality-checks/equal-to-field/faq/)

*Last updated: October 19, 2026.*
