Profiler Object:Column-Based State/Province Statistics: Difference between revisions
Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..." |
No edit summary |
||
| 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
The statistics are only accumulated for the DataTypeStateOrProvince and DataTypeCityStateZip data types. See ProfilerDataType Enumerations for details. They should only be retrieved after calling the ProfileData function.
GetColumnStateCount
This function returns a column's number of records that contain US States, both standardized and non-standardized.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records containing US States. |
| Syntax | profiler->GetColumnStateCount(columnNameStr);); |
|---|---|
| C | integer = mdProfilerGetColumnStateCount(profiler, columnNameStr); |
| .Net | integer = profiler.GetColumnStateCount(columnNameStr); |
GetColumnProvinceCount
This function returns a column's number of records that contain Canadian Provinces, both standardized and non-standardized.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain Canadian Provinces. |
| Syntax | profiler->GetColumnProvinceCount(columnNameStr);); |
|---|---|
| C | integer = mdProfilerGetColumnProvinceCount(profiler, columnNameStr); |
| .Net | integer = profiler.GetColumnProvinceCount(columnNameStr); |
GetColumnStateProvinceNonStandardCount
This function returns a column's number of records that contain non-standardized US States or non-standardized Canadian Provinces.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain non-standardized US States or non-standardized Canadian Provinces. |
| Syntax | profiler->GetColumnStateProvinceNonStandardCount(columnNameStr);); |
|---|---|
| C | integer = mdProfilerGetColumnStateProvinceNonStandardCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnStateProvinceNonStandardCount(columnNameStr); |
GetColumnStateProvinceInvalidCount
This function returns a column's number of records that contain unrecognized US States or unrecognized Canadian Provinces.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain unrecognized US States or unrecognized Canadian Provinces. |
| Syntax | profiler->GetColumnStateProvinceInvalidCount(columnNameStr);); |
|---|---|
| C | integer = mdProfilerGetColumnStateProvinceInvalidCount(profiler, columnNameStr); |
| .Net | integer = profiler.GetColumnStateProvinceInvalidCount(columnNameStr); |
GetColumnStateZipCodeMismatchCount
This function returns a column's number of records where there is a ZIP code that does not match the State. Only the 5-digit ZIP code is validated (not Plus 4.) This check is only to the state level, address and city information is not checked. Also, this statistic is only computed when both DataTypeStateOrProvince and DataTypeZipOrPostalCode are present or DataTypeCityStateZip is used. See ProfilerDataType Enumerations for details.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain mismatched values for ZIP code and State. |
| Syntax | profiler->GetColumnStateZipCodeMismatchCount(columnNameStr);); |
|---|---|
| C | integer = mdProfilerGetColumnStateZipCodeMismatchCount(profiler, columnNameStr); |
| .Net | integer = profiler.GetColumnStateZipCodeMismatchCount(columnNameStr); |
GetColumnProvincePostalCodeMismatchCount
This function returns a column's number of records where there is a Postal Code that does not match Province. This check is only to the province level, address and city information is not checked. Also, this statistic is only computed when both DataTypeStateOrProvince and DataTypeZipOrPostalCode are present or DataTypeCityStateZip is used. See ProfilerDataType Enumerations for details.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain mismatched values for Postal code and Province. |
| Syntax | profiler->GetColumnProvincePostalCodeMismatchCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnProvincePostalCodeMismatchCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnProvincePostalCodeMismatchCount(columnNameStr); |