0 ×

JoinSorted

NGS related nodes for KNIME Workbench version 0.2.200.v201510231057 by Bernd Jagla, Institute Pasteur

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.

Input Ports

Input table 1
Input table 2

Output Ports

Joined table

Best Friends (Incoming)

Best Friends (Outgoing)

Update Site

To use this node in KNIME, install NGS related nodes for KNIME Workbench from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.