You use the Data Comparison Calculator to help you determine which comparison routine and appropriate score for fields to use for the relationship linking process. The following table describes Relationship Linker comparison routines and routine modifiers.
| Routine | Modifier | Description |
|---|---|---|
| ABSOLUTE | UC | Compares two fields for an EXACT match only. Use the UC modifier to do Asian character field comparisons that determine the exact match. The UC modifier becomes enabled when you select Asian encoding. |
| APTNO | 01 | Compares two apartment numbers (assumes fields are right-justified). |
| ARRAY1 | ARRAY1,n | Compares elements of one field to elements of another field, where n is the number of bytes per segment to compare. |
| ARRAY2 | ARRAY2,n | Compares elements of one field to elements of another field, where n is the number of bytes per segment to compare. |
| BUSNAME |
ACRONYM ALPHANUM COMPACT DECOMP DI NOCASE SORT |
Compares two business names. |
| CHARACTER | (China, Japan, Korea, Taiwan) Character field comparison and score determination for Asian characters. The score is calculated based on the ratio of the number of the same characters in the both fields out of the total number of characters of those fields. The CHARACTER routine becomes enabled when you select Asian encoding. | |
| DATE |
DATEJPUC
|
Compares two dates. If you are comparing Japanese dates, select the JP modifier; for Chinese, Korean, and Taiwanese dates, select the UC modifier. The Asian-style dates are automatically converted to YYYYMMDD format. The JP and UC modifiers become enabled when you select Asian encoding. |
| DIFFER | [1][2][3][4][5] | Compares two 9-byte numeric field values. |
| DISTANCE |
KM MI NM [DIST90] [DIST80] [DIST70] [DIST60] [DIST50] |
Compares the distance between two (2) points represented by latitude and longitude. |
| FLAG10 | Identifies a relationship between a 1 or a 0 to a blank value. | |
| FLAGFM | Identifies a relationship between the female gender and anything else. | |
| FLAGGN | Identifies the relationship between genders. | |
| FLAGMF | Identifies a relationship between the male gender and anything else. | |
| FLAGYN | Determines the relationship between text flagged as either YES or NO. | |
| FRSTNAME | DIINITIALTSB | Compares two first names (assumes fields are left-justified and blank-filled). |
| GENER | 95 | Compares two generation values. |
| HOUSENO | 01 NORANGE PARITY | Compares two house numbers. |
| MXDNAME | Applies SUBSTRNG-like logic to two records, when the name form values are different. | |
|
|
ANCHOR DAMERAU EXACT RECIPROCAL TOLERANCE |
Compares two strings by measuring distance. The Levenshtein distance is defined as the minimum number of edits required to transform one string into the other, with the allowable edit operations being insertion, deletion, or substitution of a single character. Note: As of V15.8.2, the LEVENSHTEIN routine is not supported for the
MATCH function in the Expression Builder.
|
| NYSIIS | Matches two strings of data, using an algorithm based on a standard NYSIIS algorithm. | |
| ONECOM | Detects a single business record. | |
| PARTIAL1 |
10 ARRAY1,nARRAY2,n FM GN MFMU YN |
Applies ABSOLUTE- like logic to compare fields for an exact match, but uses different scores for blanks. |
| PARTIAL2 |
DATE NYSIIS RNYSIIS RSOUNDEX1 RSOUNDEX2 SOUNDEX1 SOUNDEX2 STATUS |
Applies ABSOLUTE- like logic to compare fields for an exact match, but uses different scores for blanks. |
| POSTCODE | TSBUC | Compares two postal code values. Use the UC modifier to compare postal code values for Japan. |
| PREFIX | Compares two name prefix values (assumes the fields to be four characters in length). | |
| PREVENT |
Prevents linking on fields named in the Field Comparison Routine Lists. |
|
| RNYSIIS | Links two strings, using a derived form of a standard NYSIIS algorithm | |
| SOCSEC | Compares two Social Security values. | |
| SOUNDEX1 | Matches two strings using a Soundex algorithm. | |
| SOUNDEX2 | Matches two strings using an improved Soundex algorithm. | |
| SPELLING |
ALPHANUM DECOMP DIJP KR NOCASE SQUISHUC |
Performs general-purpose text comparisons (assumes input fields are left-justified and blank-filled). Use the JP modifier to compare two Japanese kana fields. Use the UC modifier to compare two fields that contain Chinese characters, Japanese kanji/kana characters, number characters and any combination of those. Use the KR modifier to compare Korean text fields. The JP, KR, and UC modifiers become enabled when you select Asian encoding. |
| STATUS | STATUS | Compares blank fields. |
| STREETS |
ALPHANUM DECOMP DITYPE NI NOCASE |
Compares street names. |
| SUBSTRING |
ANDUC |
Identifies a string of characters (Field1) that exists within another string of characters (Field2), excluding blank strings. Use the UC modifier to detect the presence of one string of characters (field 2) within another string of characters (field 1) and perform matching for Chinese, Japanese and Korean text. The UC modifier becomes enabled when you select Asian encoding. |
| TOKENIZE |
ALPHANUM DECOMP DINOCASE PHRASE2 SQUISH |
Allows fields to be matched on a token by token basis. |
| TWORET | LO | Detects two consumer records. |