|
|
| (One intermediate revision by the same user not shown) |
| Line 2: |
Line 2: |
| [[Profiler Object:Reference|← Profiler Object Reference]] | | [[Profiler Object:Reference|← Profiler Object Reference]] |
|
| |
|
| {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;" | | {{ProfilerObjectNav |
| ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
| | |ColumnBasedStatisticsCollapse= |
| |-
| | }} |
| | style="padding-right:220px;"|
| |
| |-
| |
| |[[Profiler Object:Initialization|Initialization]]
| |
| |-
| |
| |[[Profiler Object:Object Information|Object Information]]
| |
| |-
| |
| |[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
| |
| |-
| |
| |[[Profiler Object:Column Specification|Column Specification]]
| |
| |-
| |
| |[[Profiler Object:Initiate Profiling|Initiate Profiling]]
| |
| |-
| |
| |[[Profiler Object:Data Input|Data Input]]
| |
| |-
| |
| |[[Profiler Object:Profiling|Profiling]]
| |
| |-
| |
| |[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
| |
| |-
| |
| |-
| |
| |
| |
| {| class="mw-collapsible" style="width:100%;" | |
| |- align="left" | |
| ! style="color:black;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black;"|[[Profiler Object:Iterators|Iterators]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black;"|[[Profiler Object:Result Codes|Result Codes]]
| |
| |-
| |
| |[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
| |
| |-
| |
| |[[Result Codes]]
| |
| |}
| |
| |}
| |
|
| |
|
|
| |
|
← 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);
|