Table Row Mismatch Finder

Compares a set of "key" columns in Table 1 with a set of "key" columns in Table 2 and returns tables showing the matches and differences.

The key columns in each table will be concatenated and compared so prior to calling this component, the columns to be combinaed as a "key" must be present in the same order on both tables.


@takbb Brian Bates 18 Aug 2023

Options

Table 1 Key Columns
Choose all Key Columns for Table 1
Table 2 Key Columns
Choose all Key Columns for Table 2

Input Ports

Icon
Table 1 to be compared
Icon
Table 2 to be compared

Output Ports

Icon
All matches and mismatches
Icon
Rows from Table 1 and Table 2 which match
Icon
Rows that are only in Table 1
Icon
Rows that are only in Table 2

Nodes

Extensions

Links