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"

Nodes

• Merge Variables3 ×
• Column Filter Configuration2 ×
• Column Selection Configuration2 ×
• DB Writer2 ×
• Duplicate Row Filter2 ×
• Show all 23 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available