Type Functions - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

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.