DQ.MATCHSCORE Function

Processes two input strings along with the name of the match definition and outputs the sensitivity for the match strings.

Category: Data Quality

Syntax

DQ.MATCHSCORE(definition_name, input1, input2, use_wildcards)

Required Arguments

definition_name

the name of the match definition to use.

input1

the first input string to check.

input2

the second input string to check.

returns

the sensitivity value.

use_wildcards

true if wildcards in generated match codes should be considered for the purpose of scoring.

Details

The DQ.MATCHSCORE function determines the highest sensitivity value where two input strings generate the same match code.

Example

data quality dq;
dq = dq_initialize();
dq.loadqkb("ENUSA");
 
integer x;
x = dq.matchscore("Name", "John Jones", "John J. Jones", false);