Join Custom Condition

Joins two tables:
t1 the TOP input table and
t2 the BOTTOM input table

Specify the columns to be returned using the column filters.
Specify the condition, using SQL (H2 Database syntax)

e.g.
t1."name" = t2."name" or t1."name"=t2."alternative_name"

table column names are case-sensitive and will work without including the double-quotes only if the table column names are all upper case.

It is best to always wrap the column names in double-quotes!

If no condition is supplied, it will perform a cross join (resulting in a table that is the product of the rows of both input tables, with every row in t1 joined to every row in t2.

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

Condition

Enter the condition to join, using the table names t1 and t2 to reference the input data on port 1 (top) and port 2 (bottom)

Nodes

• String Manipulation (Variable)3 ×
• Column Filter Configuration2 ×
• DB Writer2 ×
• Extract Column Header2 ×
• GroupBy2 ×
• Show all 15 nodes

Extensions

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

Links

• No links available