10 Replies Latest reply: Feb 13, 2014 8:35 AM by Ralf Becher RSS

    Remove duplicates

    Shashank Seth

      Hi Geniuses,

       

      I have various columns in table but I am facing problem with three columns

       

      Below is the small dataset of big problem

       

       

      SupplierCode SupplierName InvoiceNo
      A02AMPTRON654789
      A0003A HARTRODT (S) LOGISTICS PTE LTD1305115
      A0003A HARTRODT S'PORE PTE LTD1305115
      A0003A HARTRODT SINGAPORE PTE LTD1305115
      A03ASEC ASIAPIN010329
      A03ASEC ASIAPIN010332
      A03ASEC ASIAPIN010335
      A03ASEC ASIAPIN010341
      A03ASEC ASIAPIN010347
      A03ASEC ASIAPIN010349
      A03ASEC ASIAPIN010352
      A03ASEC ASIAPIN010353
      A03ASEC ASIAPIN010358
      A03ASEC ASIAPIN010364

       

       

      If you see here for the supplier A003 there are like common names I want only one name out of the 3 but for the supplier A03 as the invoices are differenrt so I wont have problem there

       

      So in nutshell wherever there is the same supplier code and invoice number pick only one supplier name or you can say pick only one row.

       

      Thanks,

      Shashank