Data Cleanse Project
- or -
Post a project like this3285
$$
- Posted:
- Proposals: 19
- Remote
- #742977
- Awarded
Virtual Assistant | Personal Assistant | SEO | Web Research | Data Entry | Email Management | Ecommerec Management | Excel | VB | SQL Server| Crystal Report
Indore
45390245325044428043274337094828788895745
Description
Experience Level: Intermediate
We're looking for someone to work with us remotely on a data cleanse project, we need this completed by Monday 13th April.
The project involves merging 6 excel databases into 1 new database (around 45k contacts)
The final database will need;
* One line per contact at each company
* Removal of duplicates
* Most senior person listed first
*A new column created categorising the company as 'Under or Over 50 Employees' the data is on a field for each company
*Some lines will have more data than others, this should be kept intact where additional data appears
Other notes;
- The 6 databases do not have the columns in the same order but they are clearly labelled so will need to be in order for the final database.
- Where the contact email is the same for multiple contacts (i.e. generic company email) just show the most senior contact.
I hope this is clear, any questions just ask :)
The project involves merging 6 excel databases into 1 new database (around 45k contacts)
The final database will need;
* One line per contact at each company
* Removal of duplicates
* Most senior person listed first
*A new column created categorising the company as 'Under or Over 50 Employees' the data is on a field for each company
*Some lines will have more data than others, this should be kept intact where additional data appears
Other notes;
- The 6 databases do not have the columns in the same order but they are clearly labelled so will need to be in order for the final database.
- Where the contact email is the same for multiple contacts (i.e. generic company email) just show the most senior contact.
I hope this is clear, any questions just ask :)
Zack Y.
100% (60)Projects Completed
77
Freelancers worked with
56
Projects awarded
19%
Last project
17 Oct 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies