En cours

Database field merge join query

I have an Excel file that has a list of U.S. hospitals (first worksheet of Excel file). Each hospital has a unique ID (second worksheet of Excel file). I need someone to link the hospitals in the first worksheet to the second worksheet in order to populate the "Provider Number" field.

I started to do this manually and realized a database programmer could do it more efficiently by writing some queries. Here's my logic:

1. Match by hospital name, address, city and state

2. If address, city and state are not available, research by phone number.

3. If #1 and #2 aren't available, then look at domain name within email address

The project objective is to try and populate as many of the blank Provider Number (Column C) fields in the first worksheet.

Compétences : Développement de bases de données, Programmation de bases de données, PHP, SQL

Voir plus : database phone number, database query phone number, phone number text field flash, community builder phone number field, symbian country code contact database phone number, magento price field database, query via register page database, add phone number field community builder, phone number input field flash, php mysql field database, phone number database, usa mobile phone number database, edit field database php mysql, track field database script, join joomla sugarcrm database, phone number field html css, sql create field database, save aspnet form field database, oscommerce phone number field contact, query show positive results database access, cell phone number activation database, query simply accounting sage database vbnet, sql adding field database, fill form field database data using ajax, freelancer programmer database bangalore phone number

Concernant l'employeur :
( 35 commentaires ) Saratoga, United States

N° du projet : #12669569

Décerné à :

inspireplatinum

Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Am confident to do the query you require. Looking forward to hearing from you!

30 $ USD en 1 jour
(0 Commentaires)
0.0

16 freelance ont fait une offre moyenne de 112 $ pour ce travail

coder786sl

Hi there, I have checked your excel file as well as your logic. Let me know if you want me to do this job done for you :) Best Regards, Kashif.

200 $ USD en 5 jours
(35 Commentaires)
6.0
omaralieissa

Hi, i'm a professional C# programmer, and i can provide you with a C# program with Access backend so you can manage your hospitals easily, please let me know if you are interested, thanks.

150 $ USD en 3 jours
(19 Commentaires)
5.1
Nawaz091993

Greetings! I am an expert PHP and database programmer and I can match the hospitals as per your criteria and populate the required field within hours. Please allow me to pursue another project and prove my worth.

60 $ USD en 1 jour
(30 Commentaires)
5.0
johnosullivan

hi - I can help you this project. I've 15+ years industry experience - it should be straightforward to load this into a database and populate the Provider Number there or just write a VBA macro to do it. happy to take Plus

111 $ USD en 1 jour
(20 Commentaires)
4.3
webtech92

Dear Client, Greetings of the day !! I have read your job description understand what exactly you want. I would like to put forward my candidature as my skills & experience are a perfect fit for this project. I belie Plus

155 $ USD en 3 jours
(7 Commentaires)
3.9
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus

150 $ USD en 1 jour
(5 Commentaires)
3.8
SamamaJaved

Hello dear, yes it is possible for me. i have good skills in database. i have checked your attached file. can do this... contact me so that we can proceed.... Thanks and have a nice day

155 $ USD en 3 jours
(8 Commentaires)
3.1
marveltech

Hi, Good day. This is Prabhu, from Marvel Technologies, Expertise in web design and development with successful and excellent track record of more than 6 years. We are a team of ten. We don't simply design and de Plus

55 $ USD en 1 jour
(4 Commentaires)
2.6
catstevens2009

Hi there! Have done this type of work before and am an excel/data expert! Please feel free to message me with any additional information or with questions if any! Thanks! -Steve

40 $ USD en 0 jours
(9 Commentaires)
3.3
infocentroidtech

Hi, I can do it. its database related operation , i'm quite expert on it. kindly initiate the discussion .

150 $ USD en 3 jours
(11 Commentaires)
2.4
SynthFX

Hi. I am interested in your task. Let us discuss it in chat. Thanks Hi. I am interested in your task. Let us discuss it in chat. Thanks

100 $ USD en 3 jours
(5 Commentaires)
1.5
draco77

Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, write VBA code to mathc your data. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I hav Plus

35 $ USD en 2 jours
(0 Commentaires)
0.0
millerd019

A proposal has not yet been provided

155 $ USD en 2 jours
(0 Commentaires)
0.0
shahzabkhan

Hi dear, I can do that for you in less budget. I've programming skill and experience. I can provide a smooth quality product to get required data from excel sheet to other sheet on every condition. If you have any Plus

45 $ USD en 3 jours
(0 Commentaires)
0.0
gagikm1

Hi, I am a Specialist (Business and Technology Consultant) and I am interested to complete this project on Freelance basis. After working ONSITE in London/UK, USA and Asia-Pacific, I have gained knowledge and exp Plus

125 $ USD en 3 jours
(0 Commentaires)
0.0
ispyhumanfly

I've worked a lot in this space. What format do you need the results in? Into a database? JSON format perhaps? I could even take it a step further and make a program that simply reads these excel documents and displays Plus

277 $ USD en 5 jours
(0 Commentaires)
0.0
50 $ USD en 1 jour
(0 Commentaires)
0.0