Using components: Cross Join

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

To join two dataflows, simply drag and drop the component menu button onto the join component:



Hint: After a Cross Join, you usually add a Select component to fix up the aliases and field order.

To cross join two sources:
  1. Add a Cross Join component in your package where two dataflows can be joined.
  2. Open the component and name it.

Feedback and Knowledge Base