Completed

Database field merge join query

This project was successfully completed by inspireplatinum for $30 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
18
Project Description

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.

Completed by:

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online