Find Jobs
Hire Freelancers

Database field merge join query

$30-250 USD

Ukończony
Opublikowano ponad 7 lat temu

$30-250 USD

Płatne przy odbiorze
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.
Identyfikator projektu: 12669569

Informację o projekcie

14 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (3 opinii)
3,9
3,9
14 freelancerzy składają oferty o średniej wysokości $113 USD dla tej pracy
Awatar Użytkownika
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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$150 USD w 1 dzień
4,9 (140 opinii)
7,3
7,3
Awatar Użytkownika
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 w 1 dzień
4,9 (140 opinii)
7,0
7,0
Awatar Użytkownika
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 have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. One of my last project was mathing data for Artist, Album and track name with data base for record label. The matching proces was realized in few steps. First mach was by exactly name of all data, next app search for match on two fields and one field. Last step of search was to count similarity between data. Whole process was succesfull in almost 96%. I'm sure that this model with some changes could be adapted to your project. What is your favorite way to comunicate? I there any posibility to get more details about this project? Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm realy good business partner. Best regards, Rafael
$35 USD w 2 dni
5,0 (2 opinii)
6,1
6,1
Awatar Użytkownika
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 w 5 dni
5,0 (42 opinii)
6,2
6,2
Awatar Użytkownika
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 w 3 dni
5,0 (34 opinii)
5,7
5,7
Awatar Użytkownika
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 a look at your sheet if you think my profile is a good fit. I'm online now and ready to work - can turn this around for you quickly. thanks john
$111 USD w 1 dzień
5,0 (28 opinii)
5,1
5,1
Awatar Użytkownika
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 w 0 dzień
4,2 (11 opinii)
3,5
3,5
Awatar Użytkownika
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 the results in a nice web page. Let me know...
$277 USD w 5 dni
5,0 (3 opinii)
2,1
2,1
Awatar Użytkownika
Hi, I can do it. its database related operation , i'm quite expert on it. kindly initiate the discussion .
$150 USD w 3 dni
3,1 (19 opinii)
3,7
3,7
Awatar Użytkownika
A proposal has not yet been provided
$155 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 question you can ask.
$45 USD w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Los Gatos, United States
5,0
73
Zweryfikowana metoda płatności
Członek od wrz 20, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.