2 Replies Latest reply: Jun 7, 2017 6:02 AM by Alice Wong RSS

    Create new field based on existing fields

    Alice Wong

      Hi there,

      I need to create a new field (Distributor) based on two existing fields ( Disti_Name , Disti_Corp_ID) with the condition shown in table below.

      Is there any way to do this other than hard code?

      Disti_Name

      Disti_Corp_ID

      Distributor

      A_B

      A B

      AB

      A_C

      A C

      AC

      A_D

      A D

      AD

       

      thanks!