Duplicate Data Merging and clean up

Zamknięty Opublikowano 6 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

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

Wprowadzanie danych Przetwarzanie danych Administrowanie bazami danych Excel

Numer ID Projektu: #16242406

O projekcie

67 ofert Zdalny projekt Aktywny 6 lat temu

67 freelancerów złożyło ofertę za $210 w tym projekcie

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 w ciągu 4 dni
(417 Oceny)
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 Więcej

$431 USD w ciągu 2 dni
(335 Oceny)
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 Więcej

$30 USD w ciągu 3 dni
(342 Oceny)
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 w ciągu 2 dni
(334 Oceny)
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 Więcej

$133 USD w ciągu 2 dni
(159 Oceny)
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 w ciągu 3 dni
(308 Oceny)
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 Więcej

$90 USD w ciągu 1 dnia
(298 Oceny)
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 w ciągu 1 dnia
(233 Oceny)
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 w ciągu 10 dni
(200 Oceny)
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 Więcej

$199 USD w ciągu 5 dni
(103 Oceny)
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 Więcej

$226 USD w ciągu 4 dni
(119 Oceny)
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 Więcej

$30 USD w ciągu 1 dnia
(74 Oceny)
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 Więcej

$110 USD w ciągu 1 dnia
(78 Oceny)
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. Więcej

$370 USD w ciągu 8 dni
(118 Oceny)
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 Więcej

$30 USD w ciągu 3 dni
(88 Oceny)
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 w ciągu 1 dnia
(74 Oceny)
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 Więcej

$388 USD w ciągu 5 dni
(29 Oceny)
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 Więcej

$250 USD w ciągu 3 dni
(38 Oceny)
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 w ciągu 10 dni
(66 Oceny)
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 Więcej

$109 USD w ciągu 10 dni
(28 Oceny)
4.9