Merge data sets

I have two tables of data and I need them merged, however there isn't a very clear link between the tables. the names between the two tables should be used to match, however they will not be identical. for example table 1 may say "product x y z 100" and table 2 may say "z y product x" - there are similarities that can be detected with an algorithm, for example number of words that are matching (but sequence of words doesn't matter as much). there is one column that will match between the two tables, but it doesn't contain unique values.

There are about 8000 rows in table 1 and 1000 rows in table 2 so there won't be 1:1 matches for all, but I'm hoping that table 2 contains all data that table 1 does. table 1 contains all unique values, so there will never be two values from table 2 that match table 1.

The output would contain all rows from table 1 and matching identification from table 2.

Taidot: Tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: excel sets data merge, merge sets data excel, vbscript merge column, data entry, data processing, excel, c++programming, database programming, algorithm, capture data pdf column column excel, excel data merge, macros work excel internet, merge column gridview, data file column parser program, merge column row gridview, excel plotting sets data different axis, macro dont work excel 2000, merge column cells gridview, merge column using vbscript, freelance work excel vba

Tietoa työnantajasta:
( 10 arvostelua ) Edmonton, Canada

Projektin tunnus: #13497317

Myönnetty käyttäjälle:


Hello Iam a java developer highly skilled in data processing I will use levehstein distance Algorithm wich is a highly recommended one for the comparison of Strings and i will fix a certain accuracy for comparison Lisää

$55 CAD 3 päivässä
(3 Arvostelua)

55 freelancers are bidding on average $134 for this job


Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with f Lisää

$160 CAD 2 päivässä
(412 arvostelua)

Hello sir,we have 8 member team and we can start work right now just give us one chance we will do our best,awaiting your [login to view URL]

$55 CAD 1 päivässä
(403 arvostelua)

HI I am ready to start the work.I can do this work [login to view URL] if you are interested to me message me..............................Thanks.

$155 CAD 3 päivässä
(194 arvostelua)

Dear Hiring Manager, I am writing in response to your advertisement for a “Data Entry Assistant ”. After carefully reviewing the experience requirements of the job description, I feel that I am perfect for this job Lisää

$155 CAD 3 päivässä
(133 arvostelua)
$250 CAD 3 päivässä
(85 arvostelua)

Hello Dear, I am an expert in Data Entry, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will pr Lisää

$250 CAD 3 päivässä
(135 arvostelua)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lisää

$133 CAD 2 päivässä
(92 arvostelua)

A proposal has not yet been provided

$100 CAD 2 päivässä
(158 arvostelua)

hello sir i understand what you need here .... i am an expert in data handling and excel ... i can tell for sure when i see the files myself ... i have done many such projects in past with excellent reviews Lisää

$200 CAD 4 päivässä
(65 arvostelua)

Hello, I am expert in data entry work. I have good experience in data entry, web research, Google documents and MS Office. My typing speed is more than 50 words per minute. I believe my skills would be ideal for you Lisää

$50 CAD 3 päivässä
(27 arvostelua)

Hello I am a Product Upload, data Entry and research specialist, with over 7 years of experience. My motto is simple: Excellence and 100% client satisfaction. My areas of work include - Product Uploading on most Lisää

$200 CAD 3 päivässä
(24 arvostelua)

Hi, I’ve gone through your requirement; I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible. P Lisää

$111 CAD 3 päivässä
(25 arvostelua)

Hi, i can do this for you. Thanks, Bojan

$77 CAD 2 päivässä
(24 arvostelua)

Dear client, how are you? I am a C/C++ programmer and mathematician. Seems task is VERY SUITABLE for me. Please check my "Profile & Work List" and hire me if my skill is in your concern. Looking forward to your res Lisää

$700 CAD 5 päivässä
(9 arvostelua)
$50 CAD 3 päivässä
(21 arvostelua)

Hi, my name is Daniel, i am an Excel Expert and vba programmer, i have a great experience processing data sets, i am sure i will find the right algorithm to match those tables

$100 CAD 2 päivässä
(13 arvostelua)

Hello, Im happy to work on this. I have done similar job for other client. Can you share more sample file. Thanks, Sheik

$100 CAD 3 päivässä
(5 arvostelua)

Sir, I have read your project description & it will be my immense pleasure to work for you. You can send in the details of your complete project work & method so we can start the work as soon as possible.

$60 CAD 4 päivässä
(24 arvostelua)

I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Lisää

$111 CAD 0 päivässä
(7 arvostelua)

My name is Williams Joy Ifeoma from Lagos, I am an ordinary participant in MMM, I provide help of 500000 naira on 31st of October, 2016 and I requested to get help of 695000 naira on 1st of December, 2016. Within 48 h Lisää

$250 CAD 3 päivässä
(8 arvostelua)