Join Like Full Outer

Joins two tables based on a selected column value in the TOP input table matching a Wilcard pattern contained in the  BOTTOM input table.
Standard SQL wildcards are used by default:
% = match any character
_ (underscore) = match a single character

The configuration allows you to specify alternative wildcards
e.g.
* match any
? match single.

This version of the Join Like component additionally returns the unmatched rows from both input tables, and optionally allows you to return the ROWID from each of the input data sources as separate columns making it easier to analyse the resultant joins

This is a convenience to allow alternative/familiar wildcards to be used.
Note though that even when supplying different wildcards, the built in % and _ will remain operational.

25 May 2023 @takbb Brian Bates

Input ports

1. Type: Table
   Table containing source value
2. Type: Table
   Table containing the "lookup" wildcard pattern to 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 (upper input table) that did not match
3. Type: Table
   Right Unmatched
   The rows from the RIGHT (lower input table) that did not match