PARTIAL1 With Modifier (ARRAY1,n) - 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

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.