2 Replies Latest reply: Oct 11, 2018 4:12 AM by Ruan Greeff RSS

    Help on if logic

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have the data like below.

      Here same trade keys is in three Different Types i.e, Internal, External and Global.

       

      Requirement is when any id present in Internal, External and Global Types need to keep that id in Internal  Type

      If there Is no Internal then need to keep in External else in Global.

       

      Please help me on this. Thanks in advance

       

      Input :

      Key                 Type            Identfier

      1578693       Internal          afv

      1578693       External        sf_erkil

      1578693       Global           huk_lop

      1578983        Internal         afv

      1578983       External        sg_kilo

      1578988        Global           hjkl

      1578988       External        siklo

      15789698      Global           olp


      Expected Output:

      Key                 Type            Identfier

      1578693       Internal          afv

      1578983        Internal         afv

      1578988       External        siklo

      15789698      Global           olp