Type Functions - 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 functions for the Type category verify values for numeric, null (empty), unique, and Boolean expressions, and convert integers to decimals and decimals to integers.

Function Name

Description

IS_EMPTY

Determines if an attribute or string is empty. Returns 1 (TRUE) if the value is empty, 0 (FALSE) if the value is not empty.

Note: A blank space is considered empty.
IS_LOGICAL

Determines if a value is Boolean, returning 1 (TRUE) if the value is a valid Boolean and 0 (FALSE) if it is not.

IS_NULL

Determines if an attribute or string is empty. Returns 1 (TRUE) if the value is empty, 0 (FALSE) if the value is not.

Note: A blank space is not considered empty. Function is not supported for Quality processes; when used in Quality, the function returns a zero (0).
IS_NUMBER

Determines if a value is a number that can be used in calculations, returning 1 (TRUE) if the value is a valid number and 0 (FALSE) if it is not.

IS_UNIQUE

Determines if a value is unique. Returns 1 (TRUE) if the value is unique. Returns 0 (FALSE) if the value if not unique.

Note: Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).Not supported for Quality processes; when used in Quality, the function returns a zero (0).
TO_DECIMAL

Converts an integer to a decimal.

TO_INT

Converts a decimal to an integer by rounding down. The TO_INT function allows input of 32 and 64 bit integers. The range is [-9223372036854775808] to [9223372036854775807], inclusive. Anything outside of that range, and all other non-numeric input returns a null value.

TYPE

Verifies the defined type of a specified attribute value as either integer, decimal, or string.