1 Reply Latest reply on Feb 15, 2021 8:39 PM by Akshada Sable

    Lookup with multiple conditions

    Vedha B New Member

      Hi,

       

      I have a requirement like below.

       

      SOURCE TABLE : EMP_WORK_A

      LOOKUP TABLE : EMP

       

       

      Lookup on EMP on month_Wid and employee_num.

      If there is not a match insert

      source row EMP_WORK_A.x_hierachy_wid

      If there is a match

      check EMP_WORK_A.x_hierachy_wid = EMP.ac_Hier_id

      if there is a match, populate EMP.Target_Hier_id

      else populate EMP_WORK_A.x_hierachy_wid

       

       

      Can anyone give quick suggestion on this?

       

       

      Thanks in advance,

      Veda