I have three databases.
1. Properietary: List of cities.(around 40,000) [Cityid1, Country Name, RegionName1, City Name, Citycustomname, countrycode]
2. Maxmind Location: List of Cities with additional fields. (300,000) [cityid2, Countrycode, RegionID, CityName, L1, L2]
3. Maxmind Regions (List of Region Codes, Region Label) [Regionid, RegionName2]
I want one database for 40,000 records as mentioned in database #1. The records from 2 and 3 needs to be merged to appropriate rows in database#1. So in the end, the final database with 40,000 rows will have the following structure.
[Cityid1, Cityid2, CountryName, RegionName1, RegionName2, City Name, CityCustomName, RegionID, L1, L2, Countrycode]
This will require both the SQL skills and Manual data verification. This can be done all manually if required but bulk can be done using the database.
Steps required:
a. Merge #2 and #3 to create a database #4. So that you get the regionname+cityname+countrycode combination.
b. Find through the database, all the records that match countrycode, Regionname, Cityname. Merge this data as specified above. Store this data in table #5.
c. Find through the database, all the records in #1 table that do not exist in table #5. Store these in table #6.
d. Manually update records in table #6.
e. Merge table #5 and table #6 to come up with finalized table.
We have a quick method to check for accuracy for each row and we will NOT pay unless the data is accurate for every row in the database.
These are all cities so Countrycode, Region etc should all match up fairly easily for the MOST part.
Again, we are OK if you wish to update the records in an excel sheet manually. We just want the final data and as we said, we can check for the accuracy of all 40K records in one click of a button if done right so do bid only if you are going to do this properly.
Payment will be done upon data verification and project completion.
Hi i can do it, please send the sample of 3 database and clarify more about step "d. Manually update records in table #6."
What do you mean by manually? you need also to lookup information from Internet for they are not in the 2,3 databases? How many of the 40K approximately would require this step?
Looking forward to hearing you,
Cuong NH
Hi There,
We can have your master table prepared for you and ensure that the work is accurate before presenting the results to you.
For 95% of the task, we endeavor that automation techniques will be used. We will be using custom SQL code to manipulate, merge, de-dupe and verify your results and we can ensure that it will be done well.
Please contact us if you would like to discuss any details further.
Thanks
MAV-IT
Basically, its a simple DATABASE FILE PROCESSING--analysis, extraction, manipulation, & storage of which I'm good at.
Backed by 20+ professional IT years you can count on the accuracy and timely delivery of the project.
Good Morning, I have excellent skills in excel. I will not manually merge the data but rather use excel formula and macro to do the job. All 40,000 data can be done in 1 day.
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.