You can try the DatabaseJoiner, FeatureMerger or FeatureJoiner to achieve this.

Those transformers didn't work for me because I am looking for something to achieve the like or contains function

Ex: keyword: Residential in table one

phrase: residential and commercial in table 2

then the keyword match the phrase

For fuzzy matching, try the InlineQuerier

select keyword,phrase from "Keyword", "List"
where lower(phrase) like lower('%'||"keyword"||'%')

Hi @boubcher

I created for example two datasets xls.

• Table1
• Table2

Inside on file Table1.xls it was created 3 values from attribute Keyword:

• Residential
• Local
• Soccer

And in the Table2.xls it was created a atttribute called Phrase with 5 values:

• Residential and commercial
• I live in this local
• I love volley
• We play soccer
• Sunday is great

In Canvas ( FME Desktop Workbench ) I used the custom transformer :FuzzyStringCompareFrom2Datasets

The results was just 3 in commum between two Readers:

I hope that it'll help you.

Attached the Workspacec template file. Workspace_Keywords.fmwt

Thanks,

Danilo

Hi @boubcher

I created for example two datasets xls.

• Table1
• Table2

Inside on file Table1.xls it was created 3 values from attribute Keyword:

• Residential
• Local
• Soccer

And in the Table2.xls it was created a atttribute called Phrase with 5 values:

• Residential and commercial
• I live in this local
• I love volley
• We play soccer
• Sunday is great

In Canvas ( FME Desktop Workbench ) I used the custom transformer :FuzzyStringCompareFrom2Datasets

The results was just 3 in commum between two Readers:

I hope that it'll help you.

Attached the Workspacec template file. Workspace_Keywords.fmwt

Thanks,

Danilo

@danilo_fme

YES DID WORK FOR ME

THANKS

Hi @boubcher

Excellent. I'm happy to help you.