0 ×

Random Matcher

KNIME Data Generation version 4.3.0.v202011191409 by KNIME AG, Zurich, Switzerland

The cells from the second table are attached to the first table. If selected, the node avoids creating duplicates from the second table. (However, if there are more rows in the first table than the second, this is not possible.)

If the user chooses a string column from both data tables, allocation depends on the values of these two columns. If possible, the new cells are chosen so that the columns match. (If there are no matches in the second column, we simply choose a random row.)

Options

Seed
the random seed
Unique selection
if selected, the node tries to minimize duplicates selected from the second table. (Slows down performance.)
1st table
column from the first table - if both are selected the node tries to select a row from the second table with the same value.
2nd table
column from the second table - if both are selected the node tries to select a row from the second table with the same value.

Input Ports

Icon
original table (these rowkeys stay)
Icon
new table (these rows are appended to the rows of the first table)

Output Ports

Icon
rows starting with cells from a row from the first table and than the cells from a row from the second table follow.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Data Generation from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

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.