Hy
can you explain how can use fuzzy to detect names present in list A but missing in list Band viceversa ?
thx
Francesco
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+19- Safer
- 1637 replies
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.
+51- Celebrity
- 2077 replies
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
+51- Celebrity
- 2077 replies
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