Project Title: Cleaning-up & De-duplicating Members Database
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 firstname.lastname@example.org.
Hi, firstly I want to dedup my database and then match those unique records to another data-set and merge both.
Add a comment