Comparison Routines - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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.

LEVENSHTEIN

 

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.