Question

matching keywords with table ?


Badge

HI !

i'm starting using FME 2018 and i would like to do something very special i don't know if i can do it ?

 

So,

i want to match two table with one attribute but sometimes this attribute is not the same in both.

exemple :

Table 1 :

"restaurant le Bistrot"

Table 2 :

"auberge le bistrot"

 

the special key word are not always at the same place.

 

my first idea was to separate every word from one of these table in list with attributesplitter and using a "tester" searching at least 2 word from lists for making a match with my first Table but that doesn work. even with "matcher"

 

do you know if my request is possible ?

 

thanks !!

 

Charles.


3 replies

Userlevel 4
Badge +30

Hi @charlesdollat​ 

 

Did you try to use the custom transformer for fuzzy?

 

FuzzyStringCompareFrom2Datasets

 

 

Thanks in Advance,

Danilo

Badge

Hi @charlesdollat​ 

 

Did you try to use the custom transformer for fuzzy?

 

FuzzyStringCompareFrom2Datasets

 

 

Thanks in Advance,

Danilo

Thank you for your answer ! this transformer seems to be perfect.

 

Unfortunately, i have an erreur message :

 

Python Exception <AttributeError>: 'NoneType' object has no attribute 'lower'

 

i think it's because i have some numbers in my attributes,

 

thank,

Userlevel 4
Badge +30

Please @charlesdollat​ 

 

Could you send me a sample your data?

Reply