The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Random Matcher

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

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

Ports

Input Ports
0 original table (these rowkeys stay)
1 new table (these rows are appended to the rows of the first table)
Output Ports
0 rows starting with cells from a row from the first table and than the cells from a row from the second table follow.
This node is contained in KNIME Datageneration provided by KNIME GmbH, Konstanz, Germany.