Profiler Object:Column-Based State/Province Statistics

← Profiler Object Reference

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