Profiler Object:Column-Based Zip/Postal Code 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:52, 2 February 2015
The statistics are only accumulated for the DataTypeZipOrPostalCode and DataTypeCityStateZip data types. See ProfilerDataType Enumerations for details. They should only be retrieved after calling the ProfileData function.
GetColumnZipCodeCount
This function returns a column's number of records that contain US ZIP codes. This includes 5-digit ZIP and ZIP Plus 4 codes.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain US Zip codes. |
| Syntax | profiler->GetColumnZipCodeCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnZipCodeCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnZipCodeCount(columnNameStr); |
GetColumnPlus4Count
This function returns a column's number of records with a full ZIP Plus 4 codes.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain full US ZIP Plus 4 codes. |
Return Value
This function returns number of records contains Plus4 in numerical form
| Syntax | profiler->GetColumnPlus4Count(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnPlus4Count(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnPlus4Count(columnNameStr); |
GetColumnZipCodeInvalidCount
This function returns a column's number of records that contain invalid US ZIP codes. This is a check against known US ZIP codes, State is not taken into account for this check.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain invalid US Zip codes. |
| Syntax | profiler->GetColumnZipCodeInvalidCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnZipCodeInvalidCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnZipCodeInvalidCount(columnNameStr); |
GetColumnPostalCodeCount
This function returns a column's number of records that contain Canadian postal codes.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get number of records contains Canadian postal code. |
| Syntax | profiler->GetColumnPostalCodeCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnPostalCodeCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnPostalCodeCount(columnNameStr); |
GetColumnPostalCodeInvalidCount
This function returns a column's number of records that contain invalid Canadian postal codes. This is a check against known Canadian postal codes, Province is not taken into account for this check.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain invalid Canadian postal codes. |
| Syntax | profiler->GetColumnPodyslCodeInvalidCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnPostalCodeInvalidCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnPostalCodeInvalidCount(columnNameStr); |
GetColumnZipCodePostalCodeInvalidCount
This function returns a column's number of records that contain neither US ZIP codes nor Canadian postal codes. The pattern doesn’t fit into either country’s postal code format.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of records that contain invalid ZIP/Postal codes. |
| Syntax | profiler->GetColumnZipCodePostalCodeInvalidCount(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetColumnZipCodePostalCodeInvalidCount(profiler,columnNameStr); |
| .Net | integer = profiler.GetColumnZipCodePostalCodeInvalidCount(columnNameStr); |