10 Replies Latest reply on Apr 2, 2020 2:17 AM by Premkumar S

    Handling duplicates data

    AMAR LOKESWAR KODATALA Active Member

      I have data as below. based on Name, Sup_code,item_type combination, I need to write first

      occurrence of the duplicate into one port, and rest to other port . let me know how can I do in informatica BDM

       

      Input :

         

      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
      7/7/20191768IJohnABCitem567
      1/27/20199871DRomnieXYZitem354
      6/27/20183456DRomnieXYZitem543
      9/10/20182345DRomnieXYZitem543

       

       

       

      First Occurrence :

         

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

       

       

      Rest output

       

         

      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/20182345DRomnieXYZitem543