ETL: Cross Join Transformation

Use the Cross Join transformation to produce a Cartesian product by combining every record from two inputs in your ETL data pipeline.

Use the Cross Join transformation to combine records from two different inputs. The cross join returns the Cartesian product of records from the two inputs. That is, it will produce records which combine each record from the left input with each record from the right input.

Cross Join inputs

Select 2 inputs and drag and drop the component menu button onto the cross join component:

If the join’s inputs contain fields with the same names, they will appear in the join output prefixed by the input’s name (e.g. adwords1::customer_id). Use a select component to fix the field aliases or remove fields that contain the same values.

You may want to use a filter component right after the cross join to use non equality filters on the data (that can’t be used with inner/outer joins)