Difference between revisions of "Profiler Object:Column-Based Name Statistics"
Jump to navigation
Jump to search
| Line 27: | Line 27: | ||
{| class="mw-collapsible" style="width:100%;" | {| class="mw-collapsible" style="width:100%;" | ||
|- align="left" | |- align="left" | ||
! style="color:black;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]] | ! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]] | ||
|- | |- | ||
|[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]] | |[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]] | ||
| Line 52: | Line 52: | ||
{| class="mw-collapsible mw-collapsed" style="width:100%;" | {| class="mw-collapsible mw-collapsed" style="width:100%;" | ||
|- align="left" | |- align="left" | ||
! style="color:black;"|[[Profiler Object:Iterators|Iterators]] | ! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]] | ||
|- | |- | ||
|[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]] | |[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]] | ||
| Line 73: | Line 73: | ||
{| class="mw-collapsible mw-collapsed" style="width:100%;" | {| class="mw-collapsible mw-collapsed" style="width:100%;" | ||
|- align="left" | |- align="left" | ||
! style="color:black;"|[[Profiler Object:Result Codes|Result Codes]] | ! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]] | ||
|- | |- | ||
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]] | |[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]] | ||
Revision as of 18:51, 2 February 2015
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); |