Transformation FunctionsExpression Builder - trillium_discovery - trillium_quality - Latest

Inline Quality and Discovery
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

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 (-).
Syntax

DEFAULT_PATTERN(attribute) = "pattern"

where

  • attribute is the value whose pattern you want to calculate.
  • pattern is the pattern you want to verify.
Example

DEFAULT_PATTERN( [Account Number]) = "a3d5" returns true if a3d5 matches the default pattern.
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
Syntax

HUMANIZE(text)

where text is the string you want to humanize.

Example

HUMANIZE(RANDOM_USAGE) returns Random Usage.

MASK

Verifies the defined mask of an attribute.

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

MASK(attribute) = mask

where

  • attribute is the value for which to generate a mask value.
  • mask is the mask value you want to verify.
Example

MASK(1H-3389BD) = "NA-NNNNAA" returns true if the mask supplied is the correct mask.
METAPHONE

Returns the metaphone code for a value.

Syntax

METAPHONE(value)

where value is the value for which to generate the metaphone.

Example

METAPHONE("color") returns KLR.
PATTERN

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

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

PATTERN(value,"type")

where

  • value represents the value for which the pattern will be returned.
  • type represents one of three pattern types: "default", "rich" or "long".
Examples
  • PATTERN("NEWS CNN","default") returns a4_a3
  • PATTERN("Lynette Diaz","rich") returns ul6_ul3.
  • PATTERN("5.00E+02","long") returns N.NNA+NN.
SOUNDEX

Returns a value's 4-character soundex code.

Syntax

SOUNDEX(value)

where value is the value for which you want to generate the soundex.

Examples
  • SOUNDEX("Washington") returns W252.
  • SOUNDEX("John") returns J500.
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.

Syntax

STANDARDIZE(value,"type")

where:

  • value is the value you want to standardize.
  • type is one of three data types whose rules are used in the conversion. The following data types and their representations are valid:
    • Decimal: D, d, or decimal
    • Integer: I, i, or integer
    • String: S, s, or string
Examples
  • STANDARDIZE(ABC,"i") returns "0".
  • STANDARDIZE(Abc,"S") returns "ABC".
  • STANDARDIZE(001,"d") returns "1.0".
  • STANDARDIZE(Abc v10,"s") returns "ABCV10".
  • STANDARDIZE(010,"decimal") returns "10.0".