Looking for help comparing 2 fields where values are repeated

[csh8428]

I have 2 fields. ValueA and ValueB and am trying to compare them to identify those with an "Actual Change". The example I'm using is an over-simplification since I can't share the actual data. In this example I will use colors. Value A and ValueB consist of the same set of values delimited by commas; however, those values can repeat anywhere from 1-8 times in either field. What I'm trying to do is identify the occurrences when ValueA != ValueB all the delimited words are different. I think the sample below will more easily describe what I'm trying to achieve than writing it out.

ValueA	ValueB	Actual Change?
Green	Green,Green	N
Blue,Blue	Blue,Blue,Blue,Blue	N
Blue	Red	Y
Yellow,Yellow	Yellow,Green	Y

Thanks for any help!

-Craig

[Emil_Kos · Accepted solution]

Hi @csh8428,

I have created a workflow for you:

First I used text to a column in order to split the data into rows. After some cleaning and sorting of the data, I just joined the data together to make it work.