DistinctValues

Writes all the distinct (unique) values found in a source dataset into a file.

Metrics are available in Data Discovery.

DuplicateClusters (Fuzzy Matching)

Provides you the ability to identify potentially duplicate records by evaluating multiple columns at the same time by using the fuzzy matching rules and match score filter.

Use RemoveDuplicatesFuzzyMatching.

DuplicateValues

Writes all the duplicate values found in a source dataset into a file.

Metrics are available in Data Discovery.

EqualRangeBinning

Calculates equal width ranges across the field values and counts the number of values in each range.

Metrics are available in Data Discovery.

Is Blank

Returns true if a field is blank, returns false otherwise. See ReplaceValue.

Is Duplicate

Returns true if a field is duplicated, returns false otherwise.

See RemoveDuplicates.

Is Null

Returns true if a field is null, returns false otherwise. See ReplaceValue.

Maximum

Calculates the maximum value of a field.

Metrics are available in Data Discovery.

Median

Calculates the median (middle of a sorted list) value of the field.

Metrics are available in Data Discovery.

Minimum

Calculates the minimum value of a field.

Metrics are available in Data Discovery.

Mode

Calculates the mode (most frequently occurring value) of the field.

Metrics are available in Data Discovery.

MostFrequentValues

Calculates the most frequent values of a field.

Metrics are available in Data Discovery.

PhoneticStringEncode

Calculates the most frequently occurring values of a field by phonetically encoding the string field using a specified algorithm.

StandardizeFormat

Changes the format of fields that contain values such as zip codes and phone numbers.

Use StandardizePostalCodeFormat and StandardizePhoneNumberFormat.

Statistics

Calculates the statistics for a numeric field: Min, Max, Mean, Median, Mode, Standard Deviation, Sum, Variance.

Metrics are available in Data Discovery.

String Encode Caverphone

This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.

String Encode Double-Metaphone

This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.

String Encode Metaphone

This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.

String Encode RefinedSoundex

This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.

String Encode Soundex

This string rule creates a field with its phonetically encoded value which can be used as an index key or simply be used with IsNotDuplicate for finding out duplicates.

String To Date

Converts a String field to a Date value populating a new field.

Use StringToConversion.

String To Double

Converts a String field to a Double value populating a new field.

Use StringToConversion.

String To Float

Converts a String field to a Float value populating a new field.

Use StringToConversion.

String To Int

Converts a String field to a Integer value populating a new field.

Use StringToConversion.

String To Long

Converts a String field to a Long value populating a new field.

Use StringToConversion.

String To Numeric

Converts a String field to a Numeric value populating a new field.

Use StringToConversion.

String To Time

Converts a String field to a Time value populating a new field.

Use StringToConversion.

String To TimeStamp

Converts a String field to a TimeStamp value populating a new field.

Use StringToConversion.

String Length

Calculates the length of a string field populating a derived field.

StringUpperCase

Converts all characters in a string field to uppercase.

Use ChangeStringCase.

StringLowerCase

Converts all characters in a string field to lowercase.

Use ChangeStringCase.

Sum

Calculate the sum of a field.
Metrics are available in Data Discovery.

Standard Deviation

Estimates standard deviation, a measure of how widely values are dispersed from the average value (the mean).
Metrics are available in Data Discovery.

Variance

Indicates how possible values are spread around the expected value.
Metrics are available in Data Discovery.