Join Contains

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)

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