Find Jobs
Hire Freelancers

Database Merge

$30-250 USD

En curso
Publicado hace casi 12 años

$30-250 USD

Pagado a la entrega
I have three databases. 1. Properietary: List of cities.(around 40,000) [Cityid1, Country Name, RegionName1, City Name, Citycustomname, countrycode] 2. Maxmind Location: List of Cities with additional fields. (300,000) [cityid2, Countrycode, RegionID, CityName, L1, L2] 3. Maxmind Regions (List of Region Codes, Region Label) [Regionid, RegionName2] I want one database for 40,000 records as mentioned in database #1. The records from 2 and 3 needs to be merged to appropriate rows in database#1. So in the end, the final database with 40,000 rows will have the following structure. [Cityid1, Cityid2, CountryName, RegionName1, RegionName2, City Name, CityCustomName, RegionID, L1, L2, Countrycode] This will require both the SQL skills and Manual data verification. This can be done all manually if required but bulk can be done using the database. Steps required: a. Merge #2 and #3 to create a database #4. So that you get the regionname+cityname+countrycode combination. b. Find through the database, all the records that match countrycode, Regionname, Cityname. Merge this data as specified above. Store this data in table #5. c. Find through the database, all the records in #1 table that do not exist in table #5. Store these in table #6. d. Manually update records in table #6. e. Merge table #5 and table #6 to come up with finalized table. We have a quick method to check for accuracy for each row and we will NOT pay unless the data is accurate for every row in the database. These are all cities so Countrycode, Region etc should all match up fairly easily for the MOST part. Again, we are OK if you wish to update the records in an excel sheet manually. We just want the final data and as we said, we can check for the accuracy of all 40K records in one click of a button if done right so do bid only if you are going to do this properly. Payment will be done upon data verification and project completion.
ID del proyecto: 1596912

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
16 freelancers están ofertando un promedio de $177 USD por este trabajo
Avatar del usuario
Expert here, please see the Pm for more details
$30 USD en 0 día
4,7 (229 comentarios)
7,1
7,1
Avatar del usuario
Hi, I have experience in this job, please contact me
$250 USD en 3 días
4,9 (95 comentarios)
5,7
5,7
Avatar del usuario
Hi, I can merge database 2 and 3 into 40,000 records mentioned in database 1. Please check inbox for more. Thank you.
$75 USD en 3 días
5,0 (62 comentarios)
5,6
5,6
Avatar del usuario
Hello Sir, I am interested to work on your project, if you do consider. Regards
$180 USD en 5 días
5,0 (24 comentarios)
5,0
5,0
Avatar del usuario
Hi i can do it, please send the sample of 3 database and clarify more about step "d. Manually update records in table #6." What do you mean by manually? you need also to lookup information from Internet for they are not in the 2,3 databases? How many of the 40K approximately would require this step? Looking forward to hearing you, Cuong NH
$250 USD en 5 días
4,7 (23 comentarios)
4,9
4,9
Avatar del usuario
Hi There, We can have your master table prepared for you and ensure that the work is accurate before presenting the results to you. For 95% of the task, we endeavor that automation techniques will be used. We will be using custom SQL code to manipulate, merge, de-dupe and verify your results and we can ensure that it will be done well. Please contact us if you would like to discuss any details further. Thanks MAV-IT
$250 USD en 4 días
4,9 (7 comentarios)
4,1
4,1
Avatar del usuario
Available to start immediately and finish as soon as possible.
$200 USD en 2 días
4,9 (11 comentarios)
4,3
4,3
Avatar del usuario
I can do it !
$125 USD en 7 días
5,0 (11 comentarios)
3,6
3,6
Avatar del usuario
Hi, I have gone through the csv's and the fips file. Please see PM.
$75 USD en 2 días
5,0 (1 comentario)
2,2
2,2
Avatar del usuario
I can do the task as you want, we are expert in handling database.
$60 USD en 3 días
4,6 (1 comentario)
1,4
1,4
Avatar del usuario
Basically, its a simple DATABASE FILE PROCESSING--analysis, extraction, manipulation, & storage of which I'm good at. Backed by 20+ professional IT years you can count on the accuracy and timely delivery of the project.
$250 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Good Morning, I have excellent skills in excel. I will not manually merge the data but rather use excel formula and macro to do the job. All 40,000 data can be done in 1 day.
$250 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan. With Regards Sri Technocrat.
$300 USD en 10 días
0,0 (0 comentarios)
3,7
3,7
Avatar del usuario
Hey, will do as per your need.
$240 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have analyzed your files and can do a good job!!!
$150 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'd like to do this project
$150 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Valencia, United States
0,0
0
Miembro desde abr 30, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.