PARTIAL1 With Modifier (ARRAY1,n) - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

The ARRAY1,n modifier is used with the PARTIAL1 routine to compare segments of a field to segments of another field, and to determine the relationship to blank values. The n is the number of bytes per segment to compare.

Table 1. Scoring for ARRAY1,n Modifier

Score

Description

100

Exact match and at least one is non-blank on both records.

90

At least one cell (non-blank) in one record can be found in any cell in the other record.

75

All cells are blank on one record and non-blank on the other record.

65

All cells are blank on both records.
Note: Blanks and zeros are considered to be the same value.