Joiner

A Joiner node joins two tables together on one or more common key values. Possible join modes: inner join, left outer join, right outer join, full outer join. Two tabs: "Joiner Settings" and "Column Selection". "Joiner Settings" defines the parameters for the join operation: join mode and column keys. "Column Selection" sets which columns to keep and/or drop and strategies to deal with duplicate columns.

Joiner

 

Resources

EXAMPLES Server: 02_ETL_Data_Manipulation/03_Joining_and_Concatenating/02_Joiner02_ETL_Data_Manipulation/03_Joining_and_Concatenating/02_Joiner*
Download a zip-archive

Video:

 

 


* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually