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

Input ports

1. Type: Table
   Input Table 1
   Table 1 to be compared
2. Type: Table
   Input Table 2
   Table 2 to be compared

Output ports

1. Type: Table
   Full report
   All matches and mismatches
2. Type: Table
   Matching
   Rows from Table 1 and Table 2 which match
3. Type: Table
   Table 1 Only
   Rows that are only in Table 1
4. Type: Table
   Table 2 Only
   Rows that are only in Table 2