Skip to main content
Question

Compare every single word from one attribute with the content of second attribute.

V
Forum|alt.badge.img

Hello kind people,

 

 

I am beginner with FME. I am working with data which were combined based on the similarity of the records. However, this matching is not perfect and manual review has to be done. I want to automate the review and I have question concerning comparing two records.

I would like to ask if there is any function which is able to compare two attributes for the same record e.g

NAME 1: KROGER STORE 456

 

NAME 2: KROGER FUEL CENTER

It would pass the test, where one word from the NAME 1 (Kroger) is dectected and included into NAME 2. Or word from NAME 2 is detected into NAME 1.

It should base on extracting every single word/number from NAME 1/NAME2 and comparing with every single word/number from NAME2/NAME1.

I will be grateful for help.

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • October 23, 2017

Hi @vid,

I suggest you the use of custom transformer FuzzyStringComparer .

This transformer compare by similarity two attributes.

I simulated here in my machine two attributes:

After i compare using this transformer. The result of similarity will be in a output attribute: _result

Thanks,

Danilo

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • October 23, 2017

use a string searcher on both attributes to get the "words".

Regexp: \\s*(\\w+)\\s*

Set all matches and submatches. Explode lists to separate outputs.

Merge both outputs unconditionaly (1=1).

Now u can use a tester to test word1 = word2.

(Alternatively you can use listconcatenator on one list and then use an "IN" in the tester.)

Reply


Helpful Members This Week

Community Stats

31,378
Posts
119,013
Replies
39,009
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.