Compare two columns with string values with delimiter

[gelvira]

Hello, 

I need to compare two columns with string values. I can do the comparison after parsing it but it is a long process. 

My Data is in Title 1 & Title 2. If they values are same irrespective of its position then I want it to display 'False', else 'True', If one column has additional values in that case I want 'True' as well, since it's not an exact match.

I replace the Title 1 '|' with ',' 

Is there any easy way to do it? Can fuzzy match work in this case? 

Title 1	Title 2	Result
null	null	False
NH|AB	AB,NH	False
AB|CD|EF	AB,CD	True
AB|CD	AB,CD	False
null	AB	True
XYZA|DEO|LOM	LOM	True
DEO	DEO,LOM	True
XYZA|DEO|LOM	DEO,LOM,XYZA	False

I would appreciate any help in this regard! 

[DataNath]

How does this look @gelvira? One way of doing it:

[Luke_C · Accepted solution]

Hi @gelvira 

Here's how I'd approach this:

1. Add record ID and standardize delimiter
2. Transpose data and split to rows
3. Sort (this gets all the values in the same order to compare)
4. Cross tab back and do the check

[gelvira]

Thanks!!!

This works. It's way straight forward than what I was doing. 

[gelvira]

Thank you!!! This is way simpler approach than what I was doing.