Joins two tables based on one reference column, introducing missing values where no corresponding entry is found.
Duplicate column names will have "_1" appended automatically.

This following shows how the node works by example. "?" stand for NULL values. The column used for joining is the first one from the input tables, the one with the numbers. The other column is just to show where the column in the result table are coming from.

• Example 1 (how it is envisioned to be used):

Please note here, that row (2,c) from table 1 and row (4,d) from table 2 end up with Null values.
Also, row (7,g) from table 1 is linked with rows (7,g) and (7,h) from table 2.
In contrast, rows (1,a) from table 1 is only joined with row (1,a) from table 2 because the following row (1,b);(1,b) can be joined directly.

Input1	Input2	Result
1  a	1  a	1  a  1  a	
1  b	1  b	1  b  1  b	
2  c	3  c	2  c  ?  ?	
3  d	4  d	3  d  3  c	
5  e	5  e	?  ?  4  d	
6  f	6  f	5  e  5  e	
7  g	7  g	6  f  6  f	
	7  h	7  g  7  g	
		7  g  7  h

• Example 2 what happens if list are not sorted or inversely sorted:

Here is an example on what happens if you don't sort the data.

Input1	Input2	Result
7  g	1  a	?  ?  1  a	
6  f	1  b	?  ?  1  b	
5  e	3  c	?  ?  3  c	
3  d	4  d	?  ?  4  d	
2  c	5  e	?  ?  5  e	
1  a	6  f	?  ?  6  f	
1  b	7  g	7  g  7  g	
	7  h	7  g  7  h	
		6  f  ?  ?	
		5  e  ?  ?	
		3  d  ?  ?	
		2  c  ?  ?	
		1  a  ?  ?	
		1  b  ?  ?     

Options

Column from table 1

Reference column from first input table

Column from table 2

Reference column from second input table

assume sorted tables

if selected the tables will not be sorted by this node.

Views

This node has no views

Workflows

• No workflows found

Links

• Knime table limit?by mlauber71 on 2020-01-16

  forum.knime.com/p/79001
• What does impact joiner node performace? Ram? CPU?by mlauber71 on 2020-02-19

  forum.knime.com/p/82095
• JOIN Large Tables | Timeby izaychik63 on 2019-09-17

  forum.knime.com/p/70325
• Concatenate Values from two tables without joiningby izaychik63 on 2022-08-15

  forum.knime.com/p/166369
• Table Normalization: Mapping (Index) Table for one key and many valuesby izaychik63 on 2019-10-29

  forum.knime.com/p/73502

Developers