Do we have a cross join component in Matillion? or how can I achieve a cross join result?

Matillion ETL
1

Do we have a cross join component in Matillion? or how can I achieve a cross join result?

2

Hi @usman.1018​

The main “join” component can perform a cross-join by setting the join condition to evaluate to true so all rows are matched to all other rows.

https://documentation.matillion.com/docs/1991923 covers it in a note under Join Condition but doesn’t explicitly call this a “cross join” - but that’s what it is: “To force a cartesian product (not recommended!) you still need to complete an expression, but you can specify a trivially true condition such as 1=1.”

Hope this helps.

Thanks,

Chika

3

Thank you!