0 ×

Random Matcher

KNIME Data Generation version 4.1.0.v201911110939 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

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

Output Ports

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.1

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped 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.

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.