Valitse organisaatio
How to Make Cross Join of Two Tables
Julkaisupäivä: Apr 13, 2024
Tehtävä
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.
Vaiheet
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-artikkelin numero
001456751
Ratkaisiko tämä artikkeli ongelmasi?
Anna palautetta, jotta voimme kehittyä!
