In Progress

Data matching & appending in Excel or SQL

Small project- looking for bids of $10

Need someone to setup queries so a master list column is referred to and based on provided keywords (most with wild card front and back) append associated flaggings.

Notes:

• % represents wild card. For example, sm%th finds "smith" and "smyth". Also %east finds "Northeast" and "Southeast"

• where % does not exist, there is no wild card

• space sensitive (Very Important)

• not case sensitive

• where there is more than one 'Job Folders' or 'Job Level' separate with ; in the same cell.

• conditions include where a keyword exists or where a keyword does not exist -append a code.

See attached for production file. Let me know if you have any questions.

Skills: Database Administration, Excel, MySQL, SQL

See more: master excel, wild code, master data, excel to sql, appending, excel file mysql, excel sql keywords, mysql append data, mysql append, Southeast, sql keyword, job matching, queries sql, excel appending, matching excel file, data matching project, mysql production, conditions excel, matching excel, production project excel, excel data matching, sql questions, excel matching, data matching, job card excel

About the Employer:
( 10 reviews ) Haymarket, Australia

Project ID: #5069879

Awarded to:

ramyrafik

Hello I'm an excel formulas expert. I can help u with this very easily. I just want to know what u mean by "conditions include where a keyword exists or where a keyword does not exist -append a code. "

$10 AUD in 1 day
(4 Reviews)
3.1

6 freelancers are bidding on average $22 for this job

firmuscode

Hi, I have wide experience in SQL and Excel. I have had a look into your excel, Please message me your exact needs. I would get the task done to you today under one hour or so.

$15 AUD in 1 day
(4 Reviews)
3.8
netquart

A proposal has not yet been provided

$25 AUD in 1 day
(9 Reviews)
3.6
PankajGupta007

Hello Sir, Our main motive is quality work. SO please review my previous work and rest assured on me. We will satisfy 101%. WORDPRESS: - [url removed, login to view] - [url removed, login to view] - [url removed, login to view] - h More

$30 AUD in 3 days
(0 Reviews)
0.0
mastermontilla

Hi,. it seems your requirements to your project was fit to my qualifications. I can re design your excel template that would help you a lot more presentable.. Feel free to see my portfolio. And i will send you later a More

$25 AUD in 3 days
(0 Reviews)
0.0
elsayedmb

A proposal has not yet been provided

$24 AUD in 1 day
(0 Reviews)
0.0