Duplicate Data Merging and clean up

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

We are doing some migration into a new system and discovered we have a lot of duplicate data on the old system see the attachment that best describes what the data looks like.

We now have a clean record on our new database after asking people to re-register

but will like to import and match contribution records from the old system into the new system one matching the right person record.

we have about 14000 people record on the old system

and about 2500 records on the new system

we are looking for a freelancer that can use an automated tool or script to go through the new people record and find all matching contribution records in the old data.

both files will be given in csv format

the expected delivery will be a csv or excel file with contribution records with duplicates merged and containing the right email and name

Введення даних Обробка даних Адміністрування баз даних Excel

ID Проекту: #16242406

Про проект

67 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

67 фрілансерів(-и) готові виконати цю роботу у середньому за $210

sobujprantor

HI How about that if we do it manually. Isn't it good? You will get the 100% correct data. IF you are interested to me message me................Thanks.

$277 USD за 4 дні(-в)
(417 відгуків(и))
7.9
FINGERRPRINT

Hi there, I have gone through the jpg instruction. we understood . we have more knowledge in excel formulas and other functions in excel. we can't do it by script or automated tool. we process this files with Більше

$431 USD за 2 дні(-в)
(335 відгуків(и))
8.1
motiur03

Dear Hiring Manager, You may see my profile here: https://www.freelancer.com/u/motiur03.html I am writing to apply for the position of Virtual Assistant. I possess seven years of experience as a virtual assistant Більше

$30 USD за 3 дні(-в)
(342 відгуків(и))
7.7
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD за 2 дні(-в)
(334 відгуків(и))
7.3
hatemfreelance4

I am very interested in Web search and data input task and also i have a good experience in this field. I am responsible and hardworking person. I want to spend my time, 40hrs per week working as a freelancer. My goa Більше

$133 USD за 2 дні(-в)
(159 відгуків(и))
6.8
sergeyborodkin

Hello. I can try to help you with this task. Could you send a files with "dirty" data to review a possibility to match records? I did similar tasks already and can predict a good number of positive matches Thanks

$161 USD за 3 дні(-в)
(308 відгуків(и))
6.9
eltamarisa85

Dear winnerschapelmd, I can start now to merge duplicate records between new record and old record with correct email and name. I don't have any work for this time, so i can spend all my time. I have completed some Більше

$90 USD за 1 день
(298 відгуків(и))
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$100 USD за 1 день
(233 відгуків(и))
6.9
Harun1986

Hello, I have best tools and manpower so I can remove duplicate and provide you fresh single data. Please feel free to ask me if you have any question? Waiting for your reply. Thank you

$161 USD за 10 дні(-в)
(200 відгуків(и))
6.7
DanielVizcaya91

Hi there. My name is Daniel. I would really like to take a look at a bigger sample of both the dirty data and the clean data, as I need to understand whether the name of the people is saved in the same format in both f Більше

$199 USD за 5 дні(-в)
(103 відгуків(и))
6.9
katilinas

Greetings, I'm ready to work on "new system duplicate data cleaning" project. Relevant Skills Excel, VBA Milestones 181 USD - code writing 45 USD - userfriendly interface I can achieve the results that you are ask Більше

$226 USD за 4 дні(-в)
(119 відгуків(и))
6.5
Devrits

Hello I am expert in Data Entry & Admin Support, working with professional ethics, including paying attention to detail and am ready to work on this project starting as soon as it is awarded to me. With over Більше

$30 USD за 1 день
(74 відгуків(и))
6.0
uhjk

hello, I can do this by creating php script but I don't understand how did you identify duplicate record in sample. How come John Doe and John Moo can be duplicate data? How did you know Moo is middle name? PS: OK, I Більше

$110 USD за 1 день
(78 відгуків(и))
6.1
iasmumbai

Hi, I understand your job requirements and can assist you in your data migration efforts and eliminate all the mentioned database concerns. I will be honored to start working on this assignment as soon as possible. Більше

$370 USD за 8 дні(-в)
(118 відгуків(и))
5.8
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office, i can write the best vba code Більше

$30 USD за 3 дні(-в)
(88 відгуків(и))
5.9
renesontiongson

Pleasure to help you. I read your post and I understand your requirements in regards with solving with duplicate, data merging and clean up. Feel free to message me to start the job. Thank you so much.

$100 USD за 1 день
(74 відгуків(и))
5.5
katiewells3

I am a technical business analyst with fifteen years experience in data processing, cleansing and transformation using Excel, VBA and SQL. I am running my own SQL Server so can easily pull your data tables in and run t Більше

$388 USD за 5 дні(-в)
(29 відгуків(и))
5.1
Sanjupanchal

Hello there!! I have reviewed your requirement and we have an extensive experience and expertise team to work on, we have comprehensive skills and knowledge of this type project. Once you reply to my bid i will b Більше

$250 USD за 3 дні(-в)
(38 відгуків(и))
5.1
alvichinolan

Hello, Good day! I can complete the project within your specified deadline. You are rest assured of the quality of my work. You can check my profile for review. Thank you.

$166 USD за 10 дні(-в)
(66 відгуків(и))
5.4
kahilH

Hello i can implement a script taking in consideration all the specifications you require to clean up the data you have it will be implemented in java ,i can also make it multithreaded program to make the process fa Більше

$109 USD за 10 дні(-в)
(28 відгуків(и))
4.9