Join Contains Full Outer

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)

Two additional output ports provide the rows that did not match from the two input tables

16 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 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 ×
• Duplicate Row Filter2 ×
• Show all 22 nodes

Extensions

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

Links

• No links available