0 ×

Join

org.andl.ra version 1.0.0.202004072326 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).

Options

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

Input Ports

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

Output Ports

Icon
The output relation resulting from the join.

Installation

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

KNIME 4.3

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.

Developers

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.