Cross

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Cross

Description

Creates an output from combining every possible row combination of each input. E.g. if the first input has N1 rows and the second input has N2 rows, then the result will have N1 X N2 rows. Also known as a 'Cartesian product' or 'cross join'.

 

Inputs

Two or more.

 

Example

 

cross-example

Options

The output depends on the vertical (Y-axis) position of the inputs.

 

Notes

It can create a very large number of rows!

 

See also

Join

Stack