Idenifying Duplicate Records

[Kmcnally]

I have been placed on a project converion from World to OneWorld and we are being stopped by duplicate records.

Does anyone have any ideas on how to correctly idenify these records for deletetion?

 

[Mike Dupaix]

This can be solved by changing the time stamp on the duplicate records. Just increment the seconds say from 47 to 48. This solved our problem.

Kmcnally <[email protected]> wrote:I have been placed on a project converion from World to OneWorld and we are being stopped by duplicate records.

Does anyone have any ideas on how to correctly idenify these records for deletetion?

 

[janicej]

I just used Access and ran a duplicate record query. Then you have to decide what to do to make them not be duplicate.

 

[SteveP]

Here is an SQL solution.

Assume field SKU has duplicates that you want to find:

select sku, count(sku) as CSKU
from library/filename
group by sku
having count(sku) > 1

this will return the skus and the number of records if there is more than one.