Relationship Linker Comparison Routines - trillium_discovery - trillium_quality

Relationship Linker Comparison Routines - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Discovery

Trillium > Trillium Quality

Version

17.2

Language

English

Product name

Trillium Quality and Discovery

Title

Trillium Control Center

First publish date

2008

Last updated

2024-07-01

Published on

2024-07-01T08:56:48.630530

This table lists the Relationship Linker Comparison routines and their associated modifiers. You can add modifiers to certain routines to provide scoring criteria that is unique to specific data in the attributes compared.

Note: All routines are case-sensitive.

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. Note: 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. Note: The CHARACTER routine becomes enabled when you select Asian encoding.
DATE	DATE JP UC	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. Note: 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 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	DI INITIAL SYMETRIC TSB	Compares two first names, assuming fields are left-justified and blank-filled.
GENER	95	Compares two generation values.
HOUSENO	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 the difference using the LEVENSHTEIN distance algorithm. The Levenshtein distance is calculated 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,n ARRAY2,n FM GN MF MU YN	Applies ABSOLUTE- like logic to compare fields for an exact match, but uses different scores for blanks.
PARTIAL2	DATE NYSIIS RNYSIIS RSOUNDEX1 RSOUNDEX1;S7 RSOUNDEX2 RSOUNDEX2;S7 SOUNDEX1 SOUNDEX1;S7 SOUNDEX2 SOUNDEX2;S7 STATUS	Applies ABSOLUTE- like logic to compare fields for an exact match, but uses different scores for blanks.
POSTCODE	TSB UC	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.
RSOUNDEX1	S7	Matches two strings using a Soundex algorithm. The input strings are reversed before the algorithm is performed.
RSOUNDEX2	S7	Matches two strings using an improved Soundex algorithm. The input strings are reversed before the algorithm is performed.
RNYSIIS		Links two strings, using a derived form of a standard NYSIIS algorithm.
SOCSEC		Compares two Social Security values.
SOUNDEX1	S7	Matches two strings using a Soundex algorithm.
SOUNDEX2	S7	Matches two strings using an improved Soundex algorithm.
SPELLING	ALPHANUM DECOMP DI JP KR NOCASE SQUISH UC	Performs text comparisons, assuming input fields are left-justified and blank-filled. JP. Compares Japanese kana fields. UC. Compares fields that contain Chinese characters, Japanese kanji/kana characters, number characters and any combination of those. KR. Compares Korean text fields. Note: The JP, KR, and UC modifiers become enabled when you select Asian encoding.
STATUS	STATUS	Compares blank fields.
STREETS	ALPHANUM DECOMP DI TYPE NI NOCASE	Compares street names.
SUBSTRNG	AND UC	Identifies a string of characters that exists within another string of characters, excluding blank strings. Use the UC modifier to detect the presence of a string of characters within another string of characters and perform matching for Chinese, Japanese and Korean text. Note: The UC modifier becomes enabled when you select Asian encoding.
TOKENIZE	ALPHANUM DECOMP DI NOCASE PHRASE2 SQUISH	Allows fields to be matched on a token by token basis
TWORET	LO	Detects two consumer records.