KNOWLEDGE BASE

How to Make Cross Join of Two Tables


Published: 10 Mar 2021
Last Modified Date: 10 Mar 2021

Question

How to make cross join of two tables in Tableau Desktop.
*The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. 

Environment

  • Tableau Desktop

Answer

Option 1

Create a Calculation such as " 1 = 1" as join clauses as below:
User-added image

Option 2

Join two fields with NOT EQUAL (<>) as below:
User-added image

NOTE: Option 2 has some restrictions of two joining fields:
1. Need to be the same Data Type
2. No same values in these two joining fields
3. No NULL values in these two joining fields
 
Did this article resolve the issue?