How to Make Cross Join of Two Tables

Published: 10 Mar 2021
Last Modified Date: 08 Jul 2022


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. 


  • Tableau Desktop


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?