I fear that it will be difficult without the join.
Is your datasource Excel?
You can try playing with many configurations of Pivoting your data
or changing the Booleans to instead be AAA,BBB, etc.
(as attached in the Forum post).
But at the end of the day, I think you will need to generate all of the combinations.
The c_affinity calculated field will drop out as TRUE after the first condition is met,
and so it will never reach DDD. Specifically, the configuration of CCC,DDD will only be able
to return CCC because it meets that as TRUE first and then drops out.
254114join.xlsx 12.9 KB
Sorry for the delay. Thanks for your response!
My data source is .csv.
I was hoping I wouldn't have to create every condition - that seems unrealistic given my timeline.
Has anyone attempted this pythonically within Tableau?