I have two data sets. One has a unique Opportunity ID per row. The other is a smartsheet where Opportunities are concatenated together by commas.
Can I join or relate these these data sets together with an "Exists" statement? If so, how?
If not, and I want to use the parse function when ingesting the data, how do I do the join across multiple parsed columns?
If neither of these options are possible, does Tableau offer a 'denormalization' function to copy the rows and make each comma separated valued unique to each row?
Hi @David Hafer ,
There's no way to do a relationship on "CONTAINS", however, you can do a cartesian join (or relationship) using a calculation of 1=1. Then you can make an extract or data source filter using the contains statement such as:
CONTAINS([SmartsheetOpportunities],[Opportunity ID])
Can you give this a shot and let us know if this is an option?
Best,
Bryce
