Sélectionner une organisation
How to Make Cross Join of Two Tables
Date de publication: Apr 13, 2024
Tâche
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.
Étapes
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
Numéro d’article de la base de connaissances
001456751
Cet article a-t-il résolu votre problème ?
Dites-nous ce que nous pouvons améliorer !
