Hy
can you explain how can use fuzzy to detect names present in list A but missing in list Band viceversa ?
thx
Francesco
+19- Safer
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.
+44- Evangelist
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
1 person upvoted this
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
1 person upvoted this
+44- Evangelist
frsisani wrote:
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
1 person upvoted this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.