Forum Discussion

meenakshi's avatar
meenakshi
New Contributor
3 years ago

Finding Duplicate data existing in Database

I have 2 fields called Product_ID and Partner Product_ID where lets say product ID is P-001 and Partner product ID is P-P-0001 which is already existing in database with this combination and again if...
koryknick's avatar
koryknick
Employee
4 years ago
Copy LinkReport

Remapping all field names can be done using the Object.mapKeys() method. For example:

Hope this helps!

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Copy LinkReport

Thank you @koryknick for the solution. It worked!
I was also able to play around with that and found a way to suffix as well as use a combination of both suffix and prefix.

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

Suffix: $.mapKeys((elem,key) => key + "_DT")

Combination of prefix and suffix: $.mapKeys((elem1,key,elem) => "SL_" + key + "_DT")

Thanks again for your help 🙂

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy LinkReport

    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)