Transformation Functions

Transformation 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 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".