Issue on communicating data from two difference system with different names
-
I am importing Data from excel-sheet to our sql server which comes from another system. Example In our sql server database Client name is Zee Entertainment Limited but in Another System Client Name is Zee Ent. ltd. or any other name format. In this way there are 10 thousands of records which is having data variations and We can not change our data which is connected to another business. Kindly give me solution. Thanks & Regards Shankar Chaurasia
-
I am importing Data from excel-sheet to our sql server which comes from another system. Example In our sql server database Client name is Zee Entertainment Limited but in Another System Client Name is Zee Ent. ltd. or any other name format. In this way there are 10 thousands of records which is having data variations and We can not change our data which is connected to another business. Kindly give me solution. Thanks & Regards Shankar Chaurasia
Create a mapping table that maps the company name from the 2 source systems to your system. This will work but is a solution fraught with disaster, presumably there is no control of the source systems input (excel as a data source :(( ) so whenever a user miss types a company name your mapping goes into the garbage.
Never underestimate the power of human stupidity RAH
-
I am importing Data from excel-sheet to our sql server which comes from another system. Example In our sql server database Client name is Zee Entertainment Limited but in Another System Client Name is Zee Ent. ltd. or any other name format. In this way there are 10 thousands of records which is having data variations and We can not change our data which is connected to another business. Kindly give me solution. Thanks & Regards Shankar Chaurasia
I would take a look at fulltext search. You can add synonyms to the index, and it can also search for proximity terms (spilling errors). The subject is much to big to cover in a forum answer, but you can start reading here[^] to get a feeling for what can be done.
Wrong is evil and must be defeated. - Jeff Ello