Skip to main content
Question

match phrase with keyword


boubcher
Contributor
Forum|alt.badge.img+11

I need to check a long list of keyword (excel1) if they are available in an even bigger list(excel2) of phrase

the end result will be

keyword 1 : phrase 228

keyword 2: phrase 228

keyword 3: phrase 230

.....etc

this case is used to much land use with standard naming

Any idea

7 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

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


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • February 1, 2019
redgeographics wrote:

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

 

 

 

 


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • February 1, 2019

For fuzzy matching, try the InlineQuerier

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

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • February 2, 2019

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
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • February 2, 2019
boubcher wrote:

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

 

 

 

 

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


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • February 3, 2019
danilo_fme wrote:

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


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • February 3, 2019
boubcher wrote:

@danilo_fme

YES DID WORK FOR ME

THANKS

Hi @boubcher

Excellent. I'm happy to help you.


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