Välj en organisation
How to Make Cross Join of Two Tables
Publiceringsdatum: Apr 13, 2024
Uppgift
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.
Steg
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
Knowledge-artikelnummer
001456751
Löste denna artikel ditt problem?
Berätta för oss vad vi kan förbättra!
