Imagine this. We have been given a list of products from company A and a list of products from company B.
Our job is to match products between the two lists. But each company might have slightl...
Updated Apr 24, 2020
Version 7.0
Blog Post
Very good. I used the earlier Fuzzy add in and was thinking about it the other day and then I came across this page today!
The Merge Menu Settings dialogue box is too big for my screen so I have to use the Tab key to get to and use the final two elections. That's a bit clunky and error prone, I think.
Transformation Table: I created on, similar to yours. I wanted & to change to and so I put & as From and and as To ... it rejected that out of hand! When I removed that row from the Transformation table, all was well except that when I said From MSFT To Microsoft, it did the opposite!
I support the idea of using a very simple example to demonstrate this feature so I will develop my own example and learn even more, I am sure.