|
<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Cross |
Create every possible row combination of every upstream dataset. 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'.
Cross 2 small datasets:

Two or more.
Options
•The output depends on the vertical (Y-axis) position of the inputs.
•It can create a very large number of rows!
•Use Clone to cross a dataset with itsself.
•Join