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 |
Solved! Go to Solution.
Hi @Sshasnk I mocked up a workflow that produces the output you describe in a couple of ways. Let me know what you think?