How to Make Cross Join of Two Tables

Published: 10 Mar 2021
Last Modified Date: 09 Dec 2022

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