Remove duplicates

[Anonymous]

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
A02	AMPTRON	654789
A0003	A HARTRODT (S) LOGISTICS PTE LTD	1305115
A0003	A HARTRODT S'PORE PTE LTD	1305115
A0003	A HARTRODT SINGAPORE PTE LTD	1305115
A03	ASEC ASIA	PIN010329
A03	ASEC ASIA	PIN010332
A03	ASEC ASIA	PIN010335
A03	ASEC ASIA	PIN010341
A03	ASEC ASIA	PIN010347
A03	ASEC ASIA	PIN010349
A03	ASEC ASIA	PIN010352
A03	ASEC ASIA	PIN010353
A03	ASEC ASIA	PIN010358
A03	ASEC ASIA	PIN010364

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

[rbecher]

I think you should treat (or fix) the supplier duplicates in the master data source. Who knows at this level which one is correct?