Are you struggling with joining tables that have no common columns or relationships? Fear not, for the cartesian join - also known as a cross join - has got you covered. In this guide, we will explore what a cartesian join is, when to use it, and how to perform one in Savant.
What is a Cartesian Join?
A cartesian join is a type of join that pairs every row in one table with every row in another table. This produces a new table that contains all possible combinations of the two original tables. The name "cartesian" comes from the cartesian product in mathematics, which also produces all possible pairs of elements from two sets.
When to Use a Cartesian Join
Cross joins should be used sparingly, as they can be computationally expensive and lead to a significantly large amount of data. They are most useful when the two tables being joined have no common columns or relationships.
For example, say you have two tables - one containing colors and the other containing shapes. If you want to see all possible combinations of colors and shapes, a cartesian join is the perfect tool for the job.
How to Perform a Cartesian Join in Savant
Performing a cartesian join in Savant is a straightforward process. Follow these simple steps:
Open the tool bar in Savant.
Add a Join tool to the canvas.
Connect the second table to the Join tool.
Click on "CROSS".
Click on "Apply".
That's it! You can now perform a cartesian join in Savant with ease. Just remember to use this powerful tool with caution, as it can lead to large amounts of data and slow down your workflow.