Question
How To Join by Clause [Table1].[Field1] Contains Substring [Table2].[Field2]
[Table1]
[Table2]
[Output]
Last Modified Date: 24 Aug 2022
Environment
- Tableau Prep Builder
Answer
1. Create following calculation for both Table1 and Table21
2. Join Table 1 and Table2 by 1=1
3. Filter join result by CONTAINS([Table1].[Field1],[Table2].[Field2])
4. Remove joinclause fields
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials