Join Contains Full Outer

Joins two tables based on a selected column value in the TOP input table containing within it, a value in the  BOTTOM input table. (i.e. the value in the bottom table is a substring of the value in the top table.)

Note that this joiner simply performs a pattern match using wildcards placed either side of the lookup value, so if the lookup value contains standard sql wildcards % and _, these will be interpreted as wildcards too)

Two additional output ports provide the rows that did not match from the two input tables

16 May 2023 @takbb Brian Bates

Input ports

1. Type: Table
   Table containing source value
2. Type: Table
   Table containing the "lookup" vales match to the source data.

Output ports

1. Type: Table
   Joined Output
   The resultant output table from the joining of the two tables
2. Type: Table
   Left Unmatched
   The rows from the left (top) table that were not matched
3. Type: Table
   Right Unmatched
   The rows from the right (bottom) table that were not matched