Blog

28
Dec

Cleaning-up & De-duplicating Members Database

Post By admin

Project Title: Cleaning-up & De-duplicating Members Database

Project Description:
I have some data that needs cleaning up. I have approx 20,000 members on a file.

Some of the members have duplicated member numbers and I want to make sure each member has a unique member number.

When the number is changed it is moved to the closest unique available number. There are approx 500 duplicated numbers.

Also, you need to look into the database to check for spelling errors/typos and correct if there are any.

Please confirm if you can do this.

For similar work requirements feel free to email us on info@datacleaningservices.com.

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin
Comments
  • 6 years ago Erik Necciai

    Hi, firstly I want to dedup my database and then match those unique records to another data-set and merge both.

    Reply

Add a comment