Join Like

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 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.

12 November 2022 @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