8 Replies Latest reply on Jun 4, 2021 7:36 AM by Arya Nymeria

    REG_MATCH expression

    Divya Karun Active Member

      Hello All,

       

      My requirement for Target_Field_A is as follows:

      If Source_Field_A like ‘%ORGIN%’ then set ORIGIN,   Else if Source_Field_A like ‘%DEST%, then set DESTINATION.   Else leave BLANK

      How can I achieve this in an Expression transformation using REG_MATCH function?

       

      Thanks,

      Divya