Drag partnumber from each datasource out onto rows or detail shelf and make sure your are blending on partnumber between both datasources then write a calculated field that aggregates them each since blends only work after aggregation. They are not row level joins.
IF MIN(datasourceA.PartNumber) =MIN(datasourceB.PartNumber) THEN "YES" ELSE "NO" END
1 of 1 people found this helpful
This was the ticket!!! Thank you, Brent!
In the attached workbook (Tableau 9.1), I connected to two data sources, A and B, each with a PartNumber column.
A has parts A, B, C, D, E, F, G, H and B has parts A, B, C, X, Y, Z.
In Tableau Desktop, I blended the two data sources on PartNumber, and created the following calculated field:
NOT ISNULL(ATTR([B].[Part Number]))
This will return True if the Part Number in A is also found in B. This results in the following Viz:
Parts.twbx 12.0 KB
Hey Steve - thanks for the response - this actually works to solve my problem, too. Turns out there is more than one way to skin the tableau cat in this instance! Thanks for the excellent demonstration & taking the time to provide a worksheet with the details.