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.
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.)
0 | original table (these rowkeys stay) |
1 | new table (these rows are appended to the rows of the first table) |
0 | rows starting with cells from a row from the first table and than the cells from a row from the second table follow. |