Decision 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

Decision Routines are the program rules and instructions used in the Commonizer. The decision routines define how rows are selected for survivorship and commonization.

Note: Routines marked " For commonization only " cannot be used to determine a surviving row.
Note: If there is a tie, the first row in the match group is selected.
Decision Routine Option Description

Lowest character value

Compares the character value of the attribute. The row that contains the lowest value will be commonized or designated as a survivor.

Example:

Row 1 = F

Row 2 = M

In this case, "F" will be selected.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

Highest character value

 

Compares the character value of the attribute. The row that contains the highest value will be commonized or designated as a survivor.

Example:

Row 1 = F

Row 2 = M

In this case, "M" will be selected.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

Lowest numeric value

Compares the numeric value of the attribute. The row that contains the lowest value will be commonized or designated as a survivor.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

Highest numeric value

Compares the numeric value of the attribute. The row that contains the highest value will be commonized or designated as a survivor.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

Least occurring value

Compares the number of occurrences of the value of the attribute. The row that contains the least occurring value will be commonized or designated as a survivor.

Example:

If "John" appears three times and "Jon" appears two times, then the record with "Jon" will be selected.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

Most occurring value

Compares the number of occurrence of the value of the attribute. The row that contains the most occurring value will be commonized or designated as a survivor.

Example:

If "John" appears three times and "Jon" appears two times, then record with "John" will be selected.

Note: The No Copy option is also available when the non-blank, non-zero, or non-blank/non-zero option is selected. See Non-blank and Non-zero Options for details.

First value

Compares the first value in the attribute. The row that contains the first value will be commonized or designated as a survivor.

Literal value

(For Commonization only)

 

Search for the specified value of the attribute. The row that contains this value will be commonized. Enter a literal value.

Example: 978-436-8900

This example searches for the literal value "978-436-8900". The literal value must be the same length as the attribute. If spaces are required in the literal string, the entire literal value must be enclosed in quotes.

Longest value  

Compares the length of the value of the attribute. The row that contains the longest value will be commonized or designated as a survivor.

Example:

Row 1 = Smith

Row 2 = Smit

In this case, "Smith" will be selected.

Shortest  

Compares the length of the value of the attribute. The row that contains the shortest value will be commonized or designated as a survivor.

Example:

Row 1 = Smith

Row 2 = Smit

In this case, "Smit" will be selected.

Survivor value found in list

( For Commonization only)

  Tests if the row is a survivor. The row that contains the survivor value will be commonized.