Join Regexp_​Like

Joins two tables based on a selected column value in the TOP input table matching a Regular Expression pattern contained in the BOTTOM input table

12 November 2022 @takbb Brian Bates

Options

Include Left unmatched rows

Tick this to include the rows from the Left (upper) input table that do not match with the Right (lower) input table.%%00010(Left Outer Join)

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 a regex pattern

Choose the column from the BOTTOM port data table that contains the regular expression 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

Nodes

• Merge Variables3 ×
• Column Filter Configuration2 ×
• Column Selection Configuration2 ×
• DB Writer2 ×
• Extract Column Header2 ×
• GroupBy2 ×
• String Manipulation2 ×
• String Manipulation (Variable)2 ×
• Table Row to Variable2 ×
• Transpose2 ×
• Boolean Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• DB Query Reader (Labs)1 ×
• H2 Connector (Labs)1 ×

Extensions

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

Links

• No links available