1 Reply Latest reply on Apr 5, 2020 5:16 AM by user165569

    Duplicates handling

    AMAR LOKESWAR KODATALA Active Member

      I have data a below, Based on Name,Sup_code and item_type I need to write first occurrence of duplicate into one port and rest to other port, How can it be done.

       

           

      DateAmountsystem_typeNameSup_codeitem_type
      2/17/202043434FBraniDEFitem354
      8/12/20178765FBraniDEFitem354
      8/9/20183643FBraniDEFitem354
      3/7/201815670FBraniDEFitem789
      5/14/201815437FBraniDEFitem789
      4/16/201915430IJohnABCitem123
      7/22/201861720IJohnABCitem123
      12/6/20191230IJohnABCitem567
      1/8/20193690IJohnABCitem567
      3/26/20185678IJohnABCitem567
      070/7/20191768IJohnABCitem567
      1/27/20199871DRomnieXYZitem354
      6/27/20183456DRomnieXYZitem543
      9/10/20182345DRomnieXYZitem543

       

       

      First occurrence of duplicate data port data :

         

      DateAmountsystem_typeNameSup_codeitem_type
      2/17/202043434FBraniDEFitem354
      3/7/201815670FBraniDEFitem789
      4/16/201915430IJohnABCitem123
      12/6/20191230IJohnABCitem567
      1/27/20199871DRomnieXYZitem354
      6/27/20183456DRomnieXYZ

      item543

       

       

       

      Rest of duplicate data :

         

      DateAmountsystem_typeNameSup_codeitem_type
      8/12/20178765FBraniDEFitem354
      8/9/20183643FBraniDEFitem354
      5/14/201815437FBraniDEFitem789
      7/22/201861720IJohnABCitem123
      1/8/20193690IJohnABCitem567
      3/26/20185678IJohnABCitem567
      070/7/20191768IJohnABCitem567
      9/10/20182345DRomnieXYZ

      item543

       

       

       

       

      Ho can we do informatica BDM