Compare with another Field

@'filed name' as value allows the user to specify internal row integrity checks.
In the following example the rule checks that 'BirthDate' column of Employees table is less than 'HireDate' column.
DTM Data Scrubber: column to column check

The reference to column can also be used in the SQL statement as shown at the following screenshot. Please note that it works slow due to rerun query for each data row of the source table.
DTM Data Scrubber: column reference in the SQL query