4 Replies Latest reply: Sep 13, 2017 3:12 PM by Anand Chouhan RSS

    Rename values in a field

    Ajinkya Bhonsle,

      Hi All,


      I have two fields in my two separate tables one from Salesforce and other sharepoint. "Campaign Type" and "Activity"



      Campaign TypeActivity
      Advertising - DigitalAdvertising - Digital
      Advertising - Offline/AdvertorialAdvertising - Offline/Advertorial
      Content SyndicationContent Syndication
      SearchPaid Search
      Search - PaidSocial Media
      Social MediaSocial Media Promotion



      What I am looking to do is map these two fields together. The issue is with "Search" and "Search - Paid" (campaign type table) which I want to group it and rename as "Paid Search" and group "Social Media" & "Social Media Promotion"(Activity table)  and rename it to "Social Media". So that we could get a proper mapping


      Can you help me with the script?