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
Solved! Go to 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.