Functions for Sets of Records - 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

The following aggregate functions are only available for creating input conditions and adding Attribute Transformations in the Set Selection utility. The Set Selection utility operates on groups or sets of similar records and has the following syntax:

IF(AVG(ATTRIBUTE)) > 100

OR

ATTRIBUTE1 = SUM(ATTRIBUTE2)

Note: The aggregate functions can only operate on attributes, not on functions of attributes.

For more information and use case examples, see About the Set Selection Utility. For information about working with expressions, see Expression Elements.

Function Name Description
ALL

Returns true if every condition is true.

Example: IF(ALL(BAL > 10000))

This operation returns true if all balances in the set are greater than 10000.

Note: This function can only used in an IF statement, using the following syntax: IF(ALL(CONDITION))
ANY

Returns true if any condition is true.

Example: IF (ANY(BAL > 10000))

This operation returns true if any balance in the set is greater than 10000.

Note: This function can only used in an IF statement, using the following syntax: IF(ANY(CONDITION))
AVG

Returns the average of the values for the specified attribute in each record.

Example: AVG_BAL = AVG(BAL)

This operation sets AVG_BAL to the mathematical average of every balance (BAL) in the set.

NUM

Returns the number of records that match the condition.

Example: LARGE_ACCOUNTS = NUM(BAL>10000)

This operation sets LARGE_ACCOUNTS to the number of records that have a balance (BAL) greater than 10000.

SUM

Returns the SUM of the values for the specified attribute in each record.

Example: TOT_BAL = SUM

This operation sets TOT_BAL to the mathematical SUM of every BAL in the set.

DEDUPE Functions DEDUPE