Cross Joiner

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.

Note: If executed in streaming mode only the top input will be processed in a streamable fashion.

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

Icon
The top table to be joined (streamable)
Icon
The bottom table to be joined (non-streamable)

Output Ports

Icon
Cross join

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Links

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.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

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

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.3.3.v202410291553
On NodePit since: 2024-07-09
Last update: 2024-11-21
Tags: Streamable
KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!