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

Options

Return Row ID Columns
If selected, this will return two additional columns containing the original row ids
Columns to return from Source table on TOP/LEFT data port
Select the columns to be returned from the table on the TOP (LEFT) data port
Columns to return from Source table on BOTTOM/RIGHT data port
Select the columns to be returned from the table on the BOTTOM (RIGHT) data port
Name of Lookup column containing a the wildcard pattern
Choose the column from the BOTTOM port data table that containsa wildcard pattern to be compared with the source column
Column from TOP input table to be compared
Choose the column that is to be matched to the range
Wildcard ANY character
Specify the character that represents "Mathing ONE OR MORE characters"
Wildcard SINGLE character
Specify the character that represents "Mathing a SINGLE character"

Input Ports

Icon
Table containing source value
Icon
Table containing the "lookup" wildcard pattern to match to the source data

Output Ports

Icon
The resultant output table from the joining of the two tables
Icon
The rows from the LEFT (upper input table) that did not match
Icon
The rows from the RIGHT (lower input table) that did not match

Nodes

Extensions

Links