Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
squashjunkie
Starting Member
9 Posts |
 Posted - 2007-02-16 : 09:28:38
|
| Hi,I am using a fuzzy lookup to cleanse data from a sales line details table, during the import process. The sales order line details contains a filed called 'reference' and this is compared to a field called 'category' in another table.Using data viewers to check through the cleansing process, I notice that the fuzzy lookup doesn't seem to match i.e.tbl.salesline.reference = 'I3' -> tbl.sales.category ='I03'the above is OK, but the lookup also returns the followingtbl.salesline.reference = 'I9' -> tbl.sales.category ='I01'The value I9 doesnt exist, and is miskeyed by user entry, and should have been 'I99'. I would have expected the fuzzy lookup to pickup the I99 value as at least two of the chrs are matching, but no, it picks the first 'I*' in the table. If I expand the fuzzy lookup to return more results, i.e. 5 per record, then it returns the first 5 results....I01, I02 I03 and so on.Is there a way of improving the fuzzy lookup itself? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-02-16 : 11:41:16
|
| we'd have to see more of your input data, matching expected results....and also your 'fuzzy' code....you have an advantage over us....you know your data/system...we don't.And 8/10 lines isn't enough to describe it for us to give you assistance. |
 |
|
|
|
|
|
Fuzzy Lookup