Account Management
Entities
Actions
Account Management
Entities
Actions
Compare allows you to compare two inputs and return the string similarity using a library of comparison methods.
Comparison Algorithms can be found under the Algorithm selection of the Compare task pane.
These include:
Each algorithm has a unique way of scoring the similarity between two values.
Below is an example of the Jaro Winkler scoring.
First Input | Second Input | Output |
---|---|---|
Microsoft | Microsoft | 100 |
Giggle | 80 | |
DQ Global | DQ Globe | 93.05556 |
The DQ.COMPARE function compares two values and gets a score between 0 and 100.
Parameters:
value1 (string), first comparison value
value2 (string), second comparison value
algorithm (string), comparison algorithm, from list:
returns (number), score of out 100