Duplicate Clusters (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 Remove Duplicates Fuzzy Matching.

Is Blank

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

Is Duplicate

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

See Remove Duplicates.

Is Not Duplicate

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

See Remove Duplicates.

Is Null

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

Maximum

Calculates the maximum value of a field.

Use Statistics.

Median

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

Use Statistics.

Minimum

Calculates the minimum value of a field.

Use Statistics.

Mode

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

Use Statistics.

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.

Use Phonetic String Encode.

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.

Use Phonetic String Encode.

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.

Use Phonetic String Encode.

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.

Use Phonetic String Encode.

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.

Use Phonetic String Encode.

String To Date

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

Use String To Conversion.

String To Double

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

Use String To Conversion.

String To Float

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

Use String To Conversion.

String To Int

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

Use String To Conversion.

String To Long

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

Use String To Conversion.

String To Numeric

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

Use String To Conversion.

String To Time

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

Use String To Conversion.

String To TimeStamp

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

Use String To Conversion.

String Length

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

StringUpperCase

Converts all characters in a string field to uppercase.

Use Change String Case.

StringLowerCase

Converts all characters in a string field to lowercase.

Use Change String Case.

Sum

Calculate the sum of a field.

Use Statistics.

Standard Deviation

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

Use Statistics.

Variance

Indicates how possible values are spread around the expected value.

Use Statistics.