Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

SQL Cross-join

I'm looking to execute a cross-join of a reference table to a master table, but realized there is no cross-join option within the join component. What is the best way to execute this in Matillion?

1 Community Answers

Matillion Agent  

Paul Johnson —

Hi Mark,
For a cross join you can use a SQL component. If its the first component in a flow you can reference the tables and use in place of a table input such as

SELECT * 
FROM table1 
CROSS JOIN table2

If its further along in a flow and you need to reference the preceeding component you can use the $T{} variable syntax like this:

SELECT * 
FROM $T{component_1}
CROSS JOIN $T{component_2}

Regards,
Paul

Post Your Community Answer

To add an answer please login