Transitive Property with multiple rows of data?

[samanthaschuchard]

Below is an example of a data set I am trying to work with. It is a list of plants, each dock at that plant, and any docks that can mix with it.

I am trying to create a rule or formula that would show that if two docks have a common mix, then they can also combine.

For example, in the data set attached, dock A can mix with B, but dock B can mix with A and C. So I want to show that dock A should also be able to mix with C. Almost like a play on the transitive property. Is this possible in Alteryx?

[Greg_Murray · Accepted solution]

Hi @samanthaschuchard,

I think something like this should work.

Thanks, 

Greg

[samanthaschuchard]

That worked perfectly. Thank you for your help!