ARRAY1 Routine - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
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

The ARRAY1 routine compares segments of one field to the segments of another field.

Note: Blanks and zeros are considered the same value.

ARRAY1 With Modifier (ARRAY1,n)  

Table 1. Scoring for (ARRAY1,n)

Score

Description

100

Exact match: at least one field 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.