The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Joiner

This node joins two tables in a database-like way. The join is based on the joining columns of both tables.

Dialog Options

Joiner settings
Join mode
If a row from the left table cannot be joined with a row from the right table (and vice versa) there are several options of handling this situation. After an Inner Join only matching rows will show up in the output table. A Left Outer Join will fill up the columns that come from the right table with missing values if no matching row exists in the right table. Likewise, a Right Outer Join will fill up the columns from the left table with missing values if no matching row in the left table exists. A Full Outer Join will fill up columns from both the left and right table with missing values if a row cannot be joined.
Joining columns
Select the columns from the left input table and the right input table that should be used for joining. You may selected a real column or the table's row ID here. You must make sure, that the type of selected columns matches. The row IDs are interpreted as StringCells.
Match all of the following: A row of the left input table and a row of the right input table match if they match in all specified column pairs.
Match any of the following: A row of the left input table and a row of the right input table match if they match in at least one specified column pairs.
Performance Tuning
Maximum number of open files: The maximum number of opened temporary files. Increase it for better performance. Enable hiliting: Select, if hiliting is enabled between input and output data. Disable, for reducing memory consumption.
Row ID separator in joined table
The row IDs of the joined table are a concatenation of the row ID of the left input table, this separator and the row ID of the right input table.
Column selection
Column Selection (Left Table and Right Table)

Exclude: This list contains the column names of the input table that are excluded.
Select: Use these buttons to move columns between the Include and Exclude list.
Include: This list contains the column names that are included.
Search: Use one of these fields to search either within the Include or Exclude list for certain column names or name substrings. Repeated clicking of the search button marks the next column that matches the search text. The check box 'Select all search hits' causes all matching columns to be selected making them movable between the two lists.
Always include all columns: If set, all columns are moved to the include list and if input changes all new columns will be in the include list, too.
Duplicate column handling
The option allows you to change the behaviour if the include lists of both input tables contain columns with the same name.
Filter duplicates: Only the columns from the left input table will show up in the output table.
Don't execute: Don't allow to execute this node if there are duplicate column names in the include lists.
Append suffix: Append a suffix to the duplicate column names from the right input table so that they also show up in the output table.
Joining columns handling
The option allows filtering the left/right joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.

Ports

Input Ports
0 Table contributing to the left part of the output table
1 Table contributing to the right part of the output table
Output Ports
0 Joined Table
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.