How to check single value with multiple values ?

[Sshasnk]

How should I segregate the below data into two, where to check if city code is present in the code column

City Code	Code
NY	NY,CA,LA,LN
IN	NY,CA,LA,LN
CK	NY,CA,LA,LN
LN	NY,CA,LA,LN

Below is the output:

Match:

City code	Code
NY	NY,CA,LA,LN
LN	NY,CA,LA,LN

Not a match:

City Code	Code
IN	NY,CA,LA,LN
CK	NY,CA,LA,LN

[JosephSerpis]

Hi @Sshasnk I mocked up a workflow that produces the output you describe  in a couple of ways. Let me know what you think?

[grazitti_sapna · Accepted solution]

Hi @Sshasnk,

Here is the solution to your problem:

I hope it helps.