Set Function - trillium_discovery - 17.2

Trillium Expression Builder

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 Expression Builder
Topic type
Administration
Overview
Installation
Reference
How Do I
Configuration
First publish date
2008
ft:lastEdition
2024-07-01
ft:lastPublication
2024-07-01T08:45:29.606589

The function for the Set category determines if a value is equal to one in a list of values.

Function Name

Description

LOOKUP

Determines if a unique attribute value is contained in the specific entity (data source).

Returns TRUE if there is one occurrence of the value in the attribute. Returns FALSE if the value is not in the attribute or if there are multiple occurrences of the value.

Note: The function is run against all rows in an attribute; rows with matching values return TRUE and rows that do not contain those values or have multiple occurrences of the value return FALSE.

Note the following guidelines:

  • The specified entity must be a fully-loaded, real entity (not dynamic).
  • Analyze the entity before running this function.
  • Not supported for Quality processes; when used in Quality, the function returns a dash (-).