Forum Discussion

Rahul's avatar
Rahul
New Contributor III
3 years ago

How to check list of string present Another Column

Hi,

I have one requirement in this there is one API return list of values comma separated and Another column coming from Snowflake and I need to compare and generate a flag
Note : order of strings are not fixed
Example Column1: [‘STRING1’,‘STRING2’,‘STRING3’,‘STRING4’]

Column2: [‘STRING1’,‘STRING2’,‘STRING3’,‘STRING4’]