March 9, 2010 at 4:24 am
Can anyone out there give some advice with using the Fuzzy Lookup transform.
I have these columns in my data source into the Fuzzy Lookup:
Postcode1
Street1
Name1
Postcode2
Street2
Name2
I want the Fuzzy Lookup to produce the output columns _Similarity and _Confidence. So far, I have done this.
But I need the postcodes to match exactly, and then have the _Similarity and _Confidence fields give figures for how well a match the Street and Name fields are.
For example, I would like an output like this:
Postcode1 Street1 Name1 Postcode2 Street2 Name2 _Similarity
PCODE1 ABC Dr Org1 PCODE1 ABC Drive Org 1 0.95
PCODE2 ABC Dr Org 2 PCODE2 ABC Dr Org 2 1.00
Any suggestions would be welcome.
March 9, 2010 at 7:52 am
Inside the Fuzzy Lookup transform, on the Columns tab, right click one of the links between the fields and select "Edit Mappings". There you can set a minimum similarity for a specific field.
Is that what you are looking for?
[font="Arial Narrow"]bc[/font]
March 9, 2010 at 8:41 am
Yes, precisely what I was after!
Many thanks!
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply