+11I 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
+60You can try the DatabaseJoiner, FeatureMerger or FeatureJoiner to achieve this.
+11You 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
+44For fuzzy matching, try the InlineQuerier
select keyword,phrase from "Keyword", "List"
where lower(phrase) like lower('%'||"keyword"||'%')
+51Hi @boubcher
I created for example two datasets xls.
Inside on file Table1.xls it was created 3 values from attribute Keyword:
And in the Table2.xls it was created a atttribute called Phrase with 5 values:
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
+51Those 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.
Inside on file Table1.xls it was created 3 values from attribute Keyword:
And in the Table2.xls it was created a atttribute called Phrase with 5 values:
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
+11Hi @boubcher
I created for example two datasets xls.
Inside on file Table1.xls it was created 3 values from attribute Keyword:
And in the Table2.xls it was created a atttribute called Phrase with 5 values:
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
+51@danilo_fme
YES DID WORK FOR ME
THANKS
Hi @boubcher
Excellent. I'm happy to help you.