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’]

5 Replies

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor

    The format of .mapKeys is very vital as I tried the below formats and it completely changed what I wanted to achieve:

    $.mapKeys((key,elem) => key+"_sfdc")
    $.mapKeys((key,elem) => "sfdc_"+key)