Выбрать организацию
How to Make Cross Join of Two Tables
Дата публикации: Apr 13, 2024
Задача
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.
Действия
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
Номер статьи базы знаний
001456751
Эта статья решила вашу проблему?
Оставьте свой отзыв, чтобы мы могли стать лучше!
