0 ×


org.andl.ra version by andl

Outputs the natural join of two relations (tables) where attributes (columns) are matched by name. Matching attributes must be of the same type.

There is no outer join, tuples (rows) that do not match are dropped from the output. Optionally the output may be restricted to just the attributes of the left hand relation (semijoin), or the inverse of that (antijoin).


Output tuples contain all attributes from both inputs.
Output tuples from the left relation that match a tuple from the right relation.
Output tuples from the left relation that DO NOT match a tuple from the right relation.

Input Ports

The left (top) input relation.
The right (bottom) input relation.

Output Ports

The output relation resulting from the join.


To use this node in KNIME, download the below referenced file, save it to your KNIME's plugin folder and restart KNIME.


You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.