In this tip you will learn to use the Fuzzy Match tool to find similar fields and to substitute to a common one of the common fields.
In this case we will use a list of commercial transactions made by different companies from a group. As we can see, the “company” field has some similar entries on its column. We can infer that those are the same field written in different ways and we want a way to create a substitution pattern to those entries.
First, connecting the table on a Fuzzy Match tool and, using the “Purge Mode”, we can configure the tool as follows:
Depending on the base that is being used, the “Match Threshold” option is going to be modified depending on the matching results obtained. In this case, the matching algorithm will find the first input in alphabetical order to use as the first column.
The result can be seen as:
To create a Find/Replace table, we should connect the Fuzzy Match tool exit in the flow configured as shown in the image bellow:
The result table from that flow will be connected in a “R” entry from a Find Replace Tool together with our initial table in the “F” entry.
And that’s it! Now you know how to use the Fuzzy Match tool to find similar fields and to substitute to a common one of the common fields.