Database field merge join query
- Status Completed
- Budget $30 - $250 USD
- Total Bids 18
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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online