# Data Quality Rules Transformation

A Data Quality Rules transformation can be used to apply one or more validation checks to incoming records. If a data quality rule fails for a record, the corresponding error message is attached to the data record. This error message as well as the record status can be mapped in downstream transformations. You can also use this information to route and filter records as well as create custom reject files and logs.

## **Steps**

To add a Data Quality Rules transformation, drag the *Data Quality Rules* object from the *Data Profiling* group in the Flow toolbox and drop it on the dataflow.

An example of what a *Data Quality Rules* object might look like is shown below.

![](/files/Abwmob5P0TrY1QWodr76)

To configure the properties of a *Data Quality Rules* object after it was added to the dataflow, right-click on it and select Properties from the context menu. The following properties are available:

* *Meta Object Builder screen:* Meta Object Builder screen allows you to add or remove fields in the field layout, as well as select their data type.

{% hint style="info" %}
**Note:** To quickly add fields to the layout, drag and drop the node Output port of the object whose layout you wish to replicate into the node Input port of the *Data Quality Rules* object. The fields added this way show in the list of fields inside the node and as well as in the *Meta Object Builder*.
{% endhint %}

* The *Data Quality Rules* screen provides the interface to manage your data quality rules.
  * Click the ![](/files/zhcj58aceyJP2UYG9Z9u)icon to create a new data quality rule.
  * Type a descriptive name for the rule in the Description field.
  * Using the Attach Rule to the Field dropdown, select which field will be returned in the transfer Profile, should the rule fail.
  * In the Expression input, enter the expression making the rule. For example, LTV > 60 and LTV <= 80. Or click … to open Expression Builder, a tool that allows you to visually build your rule using Record tree and Intellisense.
  * Click *Compile* to check for any syntax errors in your rule. The Status should read *Successful* for a successful compilation.

If your data quality rule has compiled successfully, enter a short message in the *Show Message* input. This custom message is displayed in the transfer Profile when a record fails the expression criteria. (If your data quality rule has not compiled successfully, correct the errors and click *Compile* again).

To activate the rule, check the Active switch.

* If the *Do not process record if rule fails* switch is checked, a record that fails the data quality rule will be filtered out by this object and will not make it to downstream objects on the dataflow.
* If the *Do not process record if rule fails* switch is cleared, a record that fails the data quality rule will be assigned the *Warning* status, but will not be filtered out by this object.

Add other data quality rules if necessary. To delete an existing data quality rule, select it and click the ![](/files/wxLe5uPkjOwC5kEsyEBa)icon.

## **Usage**

![](/files/Hn5IrWL6FLfEJPN6WsAf)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v7/dataflows/transformations/data-quality-rules-transformation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.