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 ? ?
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.
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.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well?
Do you think, the search results could be improved or something is missing?
Then please get in touch! Alternatively, you can send us an email to email@example.com,
follow @NodePit on Twitter,
or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.