4 Replies Latest reply: May 21, 2015 4:28 AM by Lance Chong RSS

    Replace field value, if condition

      Hi,

       

      I have a table in which I want to replace certain field names subject to one condition. I have a table with three fields as below. I want to replace the field value in Identifier with Identifier 2 if the activity is Abnormal or Insufficient. The result table is found below in which I added the changes in bold font. Thank you in advance!

       

      Initial table:

      IdentifierActivityIdentifier 2
      123Normal321
      1234Normal4321
      12345Abnormal54321
      123456Insufficient654321

       

      Result table:

      IdentifierActivityIdentifier 2
      123Normal321
      1234Normal4321
      54321Abnormal54321
      654321Insufficient654321