IconCross Joiner0 ×

KNIME Base Nodes version 3.6.0.v201807061308 by KNIME AG, Zurich, Switzerland

Performs a cross join of two tables. Each row of the top table is joined with each row of the bottom table. Note, this is an extremely expensive operation as the number of rows in the output is the product of both input table row counts, by increasing the chunk size there will be a speed up.

Options

Bottom table's column suffix
The suffix attached to a column's name if the bottom table contains a column with the same name. The column names of the first inport are always retained. If there are duplicates found in the second table the suffix is added once or multiple times to ensure uniqueness.
Separator for new RowIds
This string will separate the rowids in the new data table. E.g. RowID1 + sep + RowID2
Chunk size:
Number of rows read at once, increasing this value yields faster execution time but also increases memory consumption.
Append top data tables RowIds
If selected a new column will be attached to the output, containing the rowids of the top data table.
Column name(top):
The name of the newly generated rowkey column.
Append bottom data tables RowIds
If selected a new column will be attached to the output, containing the rowids of the bottom data table.
Column name(bottom):
The name of the newly generated rowkey column.

Input Ports

The top table to be joined
The bottom table to be joined

Output Ports

Cross join

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following 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.