Compare two data sources
Mirjam Schuke
Administrator
The Compare step allows you to detect and highlight differences between two data sources, e.g. year on year sales data or monthly customer sign ups. There are 3 outputs available to help determine if changes are as expected or if not, need further investigation.
- Results by key: quickly see if records have changed based on the expectations set.
- Summary: differences between the two data sources, e.g. total records, missing and changed records, columns compared and the number of changes per column.
- Detailed comparison: differences between columns compared side by side.
It is possible to exclude columns that are not of interest and you can set the type of comparison per column, e.g. Equals, More than, Less than. There is also the option to define the strictness for an Equals comparison.
The Compare step update was released in v2.13 in January 2024.
Tagged:
4