Find sub-content differences between 2 cells

[pohrt]

Hello all, 

I have 2 cells in each row with values that are separated by commas (see simplified example). I need to compare the content and find the differences.

The real examples are longer (up to 200 comma delimiters) and I have something like 40 - 300 rows that have these strings.

I was thinking that I could

1) use the TEXT to COLUMN PARSE tool (since the delimiter is always a comma) to spread the Data A and Data B out to more columns

2) then I somehow need to compare each Column from Data A with each Column from Data B

3) I need to do this for each of the rows individually

4) I was hoping to get a result that gives me the a) COMMON Values and then the b) Additional Values for Data A and the c) Additional Values for Data B

I played with transform and Joint Match ... but I am not getting to a solution where I can do this comparison easily for a larger number of values and more rows .....

Does anyone else has an idea???

Thanks so much already,

petra

[Qiu · Accepted solution]

@pohrt 
How about something like this.

I sepearte the data stream to 2 and use Text To Columns given the delimeter is always ','.

[flying008]

Hi, @pohrt 

Just try it like @Qiu :

[pohrt]

Hello Qiu, great solution ..... awesome ... works very well ...

One more question: when you use the TRANSFORM SUMMARIZE tool ... is it a good solution to carry other attributes along (that I want to use later) by adding them to the tool with "GROUP BY"? 

THANK YOU!

Petra

[pohrt]

Thank you I got this to work!

Appreciate your help

Petra

[Qiu]

@pohrt 
I would suggest to use a Join tool to bring the other attributs back to the main data stream as below.

[pohrt]

Oh Ok that makes more sense and is cleaner.

thanks again

Petra