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

Options

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 ×
• Extract Column Header2 ×
• Show all 14 nodes

Extensions

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

Links

• No links available