Seleziona un'organizzazione
How to Make Cross Join of Two Tables
Data pubblicazione: Apr 13, 2024
Operazione
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.
Fasi
Option 1
Create a Calculation such as " 1 = 1" as join clauses as below:
Option 2
Join two fields with NOT EQUAL (<>) as below:
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
Numero articolo Knowledge
001456751
Questo articolo ha risolto il problema?
Facci sapere, così possiamo migliorare!
