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

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 Lookup/Enrichment 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 the source value

Choose the column from the BOTTOM port data table that contains the value of the source column as a substring

Column from TOP input table to be compared

Choose the column that is to be matched to the range

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