Blog

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.

Comments

5 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

Great solution for complex requirement. This is really wonderful. Thank you for great services. You are high on my reliable provider list. So i have to ask, can you share your birthday and month with me. I want to make sure than when birthday comes, i wish you a good one.

Dr. Alain Briançon, Co-Founder/CEO Kitchology Inc.
If you have internal data which needs to be scrubbed, definitely get in touch with Raj and his team. They helped us maintain a squeaky clean dataset, maximizing our sales and marketing efforts. Efficient, diligent, communicative, and capable. Highly recommended.

Reed Mollins, VP Business Development at Doctor.com