Profiler Object:Column-Based State/Province Statistics

From Melissa Data Wiki
Jump to navigation Jump to search

← 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 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);