176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Data Matching Between Files
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 28, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, May 23, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I will pass 2 excel files.
Source - approximately 29K records
Match file - approximately 15K records

The end result is to have a Match File come back with two additional columns populated: match id and match set.

The Source file has a column called id. This is the unique identifier for the record in our crm. The Match file does not have this information and needs to.

I would like 4 stages of matching:
1. Stage 1: Match on First Name, Last Name, email and phone (note, there are 2 phone # columns in each file, but the match only has to have 1 record phone # on the Match file match to 1 phone # on the Source File)
a. Note: Some of the records have blank names. A blank name to a blank name field is not considered a match.
2. Stage 2: Match on First Name, Last Name, email
3. Stage 3: First Name, Last Name, phone
4. Stage 4: Match on phone only
5. Stage 5: Match on email only

I want to get the Match file back with the ID column showing the matching id of the record from t...

Sign in or Register to see more

Job ID: 41909026
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Pakistan  |  
I am MS Excel expert with extensive knowledge of VBA Programming and User forms. I am an actuarial graduate with around 3 years of experience in...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 42245479  |  Submitted: May 31, 2013 13:40 ET 
Proposal SEALED

Manisha J.      
Manisha J.'s identity has been verified.  Learn More
 India  |  
Customers satisfaction is our motto
2
  |  
 5.0   |  $250 Earnings   |  0 Jobs
Bid ID: 42194787  |  Submitted: May 30, 2013 12:42 ET 
Proposal SEALED

 India  |  
***QUALITY SOLUTION IN QUICK TIME*** Rich 10 years of experience working with Top MNCs and a European Investment Bank. TOP 5% in Analytical Skills...
8
  |  
 4.9   |  Private   |  7 Jobs
Bid ID: 42032883  |  Submitted: May 27, 2013 08:22 ET 
Proposal SEALED

 Poland  |  
I'm a certified SAS Expert with 5 years of experience. I'm also Java programmer with 5 years of experience in this area.
6
  |  
 5.0   |  Private   |  18 Jobs
Bid ID: 42028018  |  Submitted: May 27, 2013 06:15 ET 
Proposal SEALED

 Pakistan  |  
We are a service provider having competent skill particularly in the following areas, Data Entry Macros development in MS Excel Research...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41993617  |  Submitted: May 26, 2013 03:35 ET 
Proposal SEALED

Tejas T.      
Tejas T.'s identity has been verified.  Learn More
 India  |  
4+ Years of experience in Excel Macro and VBA development. I have developed 300+ Excel Macro till now. Creating Excel Macros is like a fun for me....
10
  |  
 4.9   |  Private   |  224 Jobs
Bid ID: 41981236  |  Submitted: May 25, 2013 13:53 ET 
Proposal SEALED

Daniel Dobre      
Daniel Dobre's identity has been verified.  Learn More
 Romania  |  
Highly motivated, driven by passion, Excel VBA developer. Over the last 3.5 years I have completed more then 150 projects, almost all of them...
9
  |  
 4.9   |  $5,315 Earnings   |  37 Jobs
Bid ID: 41951287  |  Submitted: May 24, 2013 14:39 ET 
Proposal SEALED

 United States  |  
I have over 16 experience years working in the IT industry in a number of different areas ranging from database applications, to office automation,...
6
  |  
 5.0   |  $932 Earnings   |  4 Jobs
Bid ID: 41948448  |  Submitted: May 24, 2013 13:21 ET 
Proposal SEALED

 India  |  
Resume: SaS Technologies SUMMARY: SaS Technologies is a place for Software and Solutions. This firm always consider 3 factors with a client...
6
  |  
 4.9   |  Private   |  6 Jobs
Bid ID: 41941209  |  Submitted: May 24, 2013 10:12 ET 
Proposal SEALED

 Russia  |  
10+ years of experience in Custom Software Development
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41935388  |  Submitted: May 24, 2013 07:24 ET 
Proposal SEALED

 India  |  
Developing Innovative Smart Efficient and Easy solutions. I develop since 2002. My main programing language is .net, asp, vb classic,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41930056  |  Submitted: May 24, 2013 04:40 ET 
Proposal SEALED

 India  |  
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
7
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 41927557  |  Submitted: May 24, 2013 03:24 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »