Difference between revisions of "Profiler Object:Column-Based Zip/Postal Code Statistics"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions 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; 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]]
|}
|}




Line 173: Line 98:


{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnPodyslCodeInvalidCount(columnNameStr);
|Syntax=profiler->GetColumnPostalCodeInvalidCount(columnNameStr);
|C=integer = mdProfilerGetColumnPostalCodeInvalidCount(profiler,columnNameStr);
|C=integer = mdProfilerGetColumnPostalCodeInvalidCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnPostalCodeInvalidCount(columnNameStr);
|.Net=integer = profiler.GetColumnPostalCodeInvalidCount(columnNameStr);
Line 194: Line 119:
|C=integer = mdProfilerGetColumnZipCodePostalCodeInvalidCount(profiler,columnNameStr);
|C=integer = mdProfilerGetColumnZipCodePostalCodeInvalidCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnZipCodePostalCodeInvalidCount(columnNameStr);
|.Net=integer = profiler.GetColumnZipCodePostalCodeInvalidCount(columnNameStr);
}}
==GetColumnStateZipCodeMismatchCount==
This function returns a column's number of records with a mismatch of US state and ZIP code.
This function takes one parameter.
===Parameters===
{{Object Parameters
|Name=ColumnNameStr
|Data Type=String
|Description=Column Name to get the number of records that contain mismatched US state and ZIP code.
}}
{{ Object Syntax
|Syntax=profiler->GetColumnStateZipCodeMismatchCount(ColumnNameStr);
|C=integer = mdProfilerGetColumnStateZipCodeMismatchCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnStateZipCodeMismatchCount(columnNameStr);
}}
==GetColumnProvincePostalCodeMismatchCount==
This function returns a column's number of records with a mismatch of Canadian province and postal code.
This function takes one parameter.
===Parameters===
{{Object Parameters
|Name=ColumnNameStr
|Data Type=String
|Description=Column Name to get the number of records that contain mismatched Canadian province and postal code.
}}
{{ Object Syntax
|Syntax=profiler->GetColumnProvincePostalCodeMismatchCount(ColumnNameStr);
|C=integer = mdProfilerGetColumnProvincePostalCodeMismatchCount(profiler,columnNameStr);
|.Net=integer = profiler.GetColumnProvincePostalCodeMismatchCount(columnNameStr);
}}
}}




[[Category:Profiler Object]]
[[Category:Profiler Object]]

Latest revision as of 00:39, 25 February 2015

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Frequency Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Profiler Object Result Codes
Result Codes


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->GetColumnPostalCodeInvalidCount(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);


GetColumnStateZipCodeMismatchCount

This function returns a column's number of records with a mismatch of US state and ZIP code.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnNameStr String Column Name to get the number of records that contain mismatched US state and ZIP code.


Syntax profiler->GetColumnStateZipCodeMismatchCount(ColumnNameStr);
C integer = mdProfilerGetColumnStateZipCodeMismatchCount(profiler,columnNameStr);
.Net integer = profiler.GetColumnStateZipCodeMismatchCount(columnNameStr);


GetColumnProvincePostalCodeMismatchCount

This function returns a column's number of records with a mismatch of Canadian province and postal code.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnNameStr String Column Name to get the number of records that contain mismatched Canadian province and postal code.


Syntax profiler->GetColumnProvincePostalCodeMismatchCount(ColumnNameStr);
C integer = mdProfilerGetColumnProvincePostalCodeMismatchCount(profiler,columnNameStr);
.Net integer = profiler.GetColumnProvincePostalCodeMismatchCount(columnNameStr);
Retrieved from "http://wiki.melissadata.com/index.php?title=Profiler_Object:Column-Based_Zip/Postal_Code_Statistics&oldid=7968"