Hy
can you explain how can use fuzzy to detect names present in list A but missing in list Band viceversa ?
thx
Francesco
Userlevel 2
+17
- Safer
- 1580 replies
-
21 February 2018
Hi @frsisani,
The FME Hub transformer FuzzyStringCompareFrom2Datasets can compare both lists and create a set of output matches with match ratios. You can test the match ratios to find the mismatches. I am attaching a workspace to illustrate.
Userlevel 4
+30
- Evangelist
- 1880 replies
-
21 February 2018
Hi @frsisani
If you want just to compare attributes similar in ListA and ListB, I would use the transformer FeatureMerger:
About the fuzzy operator I used the custom transformer FuzzyStringComparer the result of this Fuzzy was the new Attribute _Result.
With the transformer AttributeRangerFilter I created the output ports respecting the percentagem:
- 50% - 60%
- 61% - 70%
- 71% - 80%
- 81% - 90%
- 91% - 100%
Attached the workspace template.
Thanks in Advance, - workspace-fuzzy.fmwt
Danilo
Hy Guys
thx for support
Another request
Now I need to run the fuzzy in batch mode comparing 5 (or more) sheet in 2 different excel file
I mean sheet1 excel_A against sheet1 excel_B
sheet2 excel_A against sheet2 excel_B
sheet3 excel_A against sheet3 excel_B
How can do this ? workspace runner ?
thx
Francesco
Userlevel 4
+30
- Evangelist
- 1880 replies
-
23 February 2018
Hy Guys
thx for support
Another request
Now I need to run the fuzzy in batch mode comparing 5 (or more) sheet in 2 different excel file
I mean sheet1 excel_A against sheet1 excel_B
sheet2 excel_A against sheet2 excel_B
sheet3 excel_A against sheet3 excel_B
How can do this ? workspace runner ?
thx
Francesco
I believe you can Work in the same Workspace in parallel process, without the use the transformer WorkspaceRunner.
Thanks,
Danilo
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.