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

dq dataq;

dataq = dq_initialize();

dataq.loadqkb("ENUSA");

 

integer x;

x = dataq.matchscore("Name", "John Jones", "John J. Jones", false);