We have a database that needs to be cleaned up and standardized. Here are the details:
1. We have a master list of around 20,000 product names.
2. We have another data set of around 8,500 product names. However these list of companies dont match with the master list. These need to be matched with the master list. In case they dont match suggestions need to be made to update the master list. Please note we have already used vlookup to match these records with the master list. We would need someone to do a vlookup and then look at each of the entries individually. Either you will have to edit the entry to align it with the product name or else suggest us to add it to the master list.
Attention to detail is a must as every entry is important!
28 freelancers are bidding on average ₹8284 for this job
Expert in creating complex joins, which helps in finding out matched and unmatched records Relevant Skills and Experience MSSQL, MYSQL, Excel Proposed Milestones ₹7777 INR - Stored procedure or function for the task