Profiler Object:Column-Based Name Statistics

← Profiler Object Reference

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);