11 Replies Latest reply on Jun 11, 2018 4:54 AM by Sohan Jawar

    Problem in Consolidating two fields to create unique field

    shwetha parashurama

      Hi All,

       

      I have two country fields like country A and Country B.  I wanted to add the values from two fields to create consolidated field.

       

      For Ex:

      Below there are two fields `Country A`  And `Country B`. I need  to Create result set like` Country C`[ where Singapore =15(10+5 )and India=10(6+4)]

       

       

      Country A
      Singapore10
      Austarlia4
      Japan12
      India6

       

       

      Country B
      India4
      Honkong7
      Singapore5
      Malaysia14

       

       

      Country C
      Austarlia4
      Honkong7
      India10
      Japan12
      Malaysia14
      Singapore15

       

       

      Thanks in advance..