Transformation 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 Transformation category convert values into metaphones, patterns, soundexes, and masks, and standardizes values by datatype.

Function Name

Description

DEFAULT_PATTERN

Verifies the pattern of a value based on the default pattern definition for the attribute which contains the value.

Note: Analyze the entity (data source) before running this function. Function is not supported for dynamic entities. Applicable only to real, fully-loaded entities. Not supported for Quality processes (except the Transformer); when used in a Quality process other than the Transformer, the function returns a dash (-).
HUMANIZE

Converts a string to make it look similar to written language text. A humanized string:

  • Is mixed case
  • Removes white space (spaces and tabs) from the beginning and the end
  • Contains spaces that were transformed from underscores
MASK

Verifies the defined mask of an attribute.

Note: Only available for the Transformer process when used in Quality.
METAPHONE

Returns the metaphone code for a value.

PATTERN

Returns a pattern representation in the specified pattern type of a value.

Note: Only available for the Transformer process when used in Quality.
SOUNDEX

Returns a value's 4-character soundex code.

STANDARDIZE

Converts a value into a standardized decimal, integer, or string. Standardizing helps determine if two or more similar values are equivalent.

For information about the decimal, integer, and string data types used in standardizing, see Standardize Rules.