7 Replies Latest reply: Nov 5, 2014 8:41 AM by viresh K RSS

    how to create a new column by using the the existing column

      Hi team,

       

      I have a field called status which contains the code from 1 to 10.

      i need to create a new column called group based on these codes.

      if code is 1 or 2 then it should be new

      if code is 3 to 5 it should be old

      if code is other then above then it should be NA

       

      can you help me to achieve this.

       

      thanks