Loading

How To Join by Clause [Table1].[Field1] Contains Substring [Table2].[Field2] in Tableau Prep

Дата публикации: Apr 13, 2024
Задача

How To Join by Clause [Table1].[Field1] Contains Substring [Table2].[Field2]

[Table1]
User-added image

[Table2]
User-added image

[Output]
User-added image
 

Действия
1. Create following calculation for both Table1 and Table2

1

User-added image

2. Join Table 1 and Table2 by 1=1

User-added image

3. Filter join result by CONTAINS([Table1].[Field1],[Table2].[Field2])

User-added image

4. Remove joinclause fields
Номер статьи базы знаний

001453837

Вложения

joinclause.tflx

9 KB

 
Загрузка
Salesforce Help | Article