Category: Transform / Advanced

This action compares two tables and produces a list of detected differences based on column metadata.

Use this action to compare the current version of a dataset against an earlier one to determine if it has changed, and what those changes were.

This action can be used to drive workflow branching based on whether the two comparison tables match.

The only setting for his action is selecting the Other table to compare to.

The result of this action is a dataset containing the columns Verdict, Column, This table, and Other table.

The following verdicts are created when columns have been added or removed between the datasets.

• Column removed (column name is missing in the other dataset)
• Column added (column name is missing in this dataset)

Tests below are performed only if the other dataset contains at least one column from the this dataset. Tests are conducted for columns from the current dataset.

• The order of columns has changed (additional pre-requisite: no columns added or removed)
• Values have become or stopped being unique
• Column vocabulary has got one or more new values
• Column vocabulary has lost one or more values
• The number of rows has increased or decreased

Tests below are performed only if the number of rows has not changed and other dataset contains at least one column from this dataset.

• Has fewer or more integer numbers
• Has fewer or more non-integer numbers
• Has fewer or more text values
• Has or doesn't have empty values
• Has or doesn't have errors
• Has or doesn't have booleans

Additional numerical and text-based comparisons.

• The min number value is different
• The max number value is different
• The min text length is different
• The max text length is different
• The min text length is different

If both tables are exactly the same the resultant dataset will be empty and the action icon will show green. Otherwise, the action icon will show red.

If both tables are completely different, the result will be a "Column removed" verdict for each column in the original dataset followed by a "Column added" verdict for each column in the comparison dataset.

Compare Table 1 to Table 2 to determine any differences.

Table 1: Table with "Compare tables" action.

Table 2: Table to compare to.

Other table: Table 2

• Table metadata