How to Make Cross Join of Two Tables

發佈時間 : 10 Mar 2021
上次修改日期 : 09 Dec 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