View source for Profiler Object:Column-Based Country Statistics


[[Profiler Object:Reference|&larr; Profiler Object Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
|- 
| 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; 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 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; 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 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; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}


<div class="toclimit-2">{{CustomTOC}}</div>

The statistics are only accumulated for DataTypeCountry columns.  See [[Profiler Object:Enumeration Listing and Parsing#ProfilerDataType Enumerations|ProfilerDataType Enumerations]] for details. They should only be retrieved after calling the '''[[Profiler Object:Profiling#ProfileData|ProfileData]]''' function.

==GetColumnCountryNonStandardCount==
This function returns a column's number of records that contain a recongnized country name in a non-ISO standard.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the number of records that contain country names in a non-ISO standard.
}}

{{ Object Syntax
|Syntax=profiler->GetColumnCountryNonStandardCount(columnNameStr);
|C=integer = mdProfilerGetColumnCountryNonStandardCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnCountryNonStandardCount(columnNameStr);
}}

==GetColumnCountryInvalidCount==
This function returns a column's number of records that contain non-recognized country names.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the number of records that contain non-recognized country names.
}}

{{ Object Syntax
|Syntax=profiler->GetColumnCountryInvalidCount(columnNameStr);
|C=integer = mdProfilerGetColumnCountryInvalidCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnCountryInvalidCount(columnNameStr);
}}


[[Category:Profiler Object]]