Exists In single field

---

Asserts if the rows of a compared table/field of a specific Datastore exists in the selected table/field.

Accepted Field Types
Date
Timestamp
Integral
Fractional
String
Boolean

Example

Account_fk exists in Account_id.

You can select the same or a different datastore to assert that the compared table/file exists in the source table/file.

Record Anomaly error messageShape Anomaly error message

The [field_name] value of '[x value]' does not exist in [compared_field_name].

In [field_names], [x]% of the filtered values do not exist in [compared_field_name].

---