Profiler Object:Column-Based Name Statistics

From Melissa Data Wiki
Revision as of 22:06, 23 February 2015 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Frequency Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Profiler Object Result Codes
Result Codes


These statistics are only accumulated for the following data types.

  • DataTypeFullName
  • DataTypeInverseName
  • DataTypeNamePrefix
  • DataTypeFirstName
  • DataTypeMiddleName
  • DataTypeLastName
  • DataTypeSuffix

They should only be retrieved after calling ProfileData function.

GetColumnNameInconsistentOrderCount

This function returns a column's number of records with name values that do not follow the data type you set for the column with the AddColumn function. (i.e., "Smith, John" for a column that you set a data type of DatatypeFullName.)

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the number of records that do not follow your set data type.


Syntax profiler->GetColumnNameInconsistentOrderCount(columnNameStr);
C integer = mdProfilerGetColumnNameInconsistentOrderCount(profiler, columnNameStr);
.Net integer = profiler.GetColumnNameInconsistentOrderCount(columnNameStr);


GetColumnNameMultipleNameCount

This function returns a column's number of records with multiple name values. (i.e., "John and Marry Smith".)

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the number of records with multiple name values.


Syntax profiler->GetColumnNameMultipleNameCount(columnNameStr);
C integer = mdProfilerGetColumnNameMultipleNameCount(profiler, columnNameStr);
.Net integer = profiler.GetColumnNameMultipleNameCount(columnNameStr);


GetColumnNameSuspiciousNameCount

This function returns a column's number of records with suspicious name values. (i.e., "Mickey Mouse".)

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the number of records with suspicious name values.


Syntax profiler->GetColumnNameSuspiciousNameCount(columnNameStr);
C integer = mdProfilerGetColumnNameSuspiciousNameCount(profiler, columnNameStr);
.Net integer = profiler.GetColumnNameSuspiciousNameCount(columnNameStr);