KNOWLEDGE BASE

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


Published: 31 Aug 2020
Last Modified Date: 01 Sep 2020

Question

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

[Table1]
User-added image

[Table2]
User-added image

[Output]
User-added image
 

Environment

  • Tableau Prep Builder

Answer

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
Did this article resolve the issue?