Profiler Object:Column-Based Value Length Frequency Table Iteration

← Profiler Object Reference

These functions allow you to step through each distinct value length for a specific column.

StartLengthFrequency

This function initiates the iterator. It returns 1 to indicate if there are records to iterate through. Otherwise it returns 0.

This function takes two parameters.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to start the iterator.
Order	Order	This specifies how to order. See Order Enumeration for details.

Syntax	int = profiler->StartLengthFrequency(columnNameStr, Order);
C	int = mdProfilerStartLengthFrequency(profiler,columnNameStr, Order);
.Net	integer = profiler.StartLengthFrequency(columnNameStr, Order);

GetLengthFrequencyValue

This function returns a column's distinct length.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the column’s distinct length.

Syntax	profiler->GetLengthFrequencyValue(ColumnNameStr);
C	integer = mdProfilerGetDataFrequencyValue(profiler,columnNameStr);
.Net	integer = profiler.GetDataFrequencyValue(columnNameStr);

GetLengthFrequencyCount

This function returns the number of times the length appears in the profiled data for this particular column.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of times the length appears in the profiled data.

Syntax	profiler->GetLengthFrequencyCount(columnNameStr);
C	integer = mdProfilerGetLengthFrequencyCount(profiler,columnNameStr);
.Net	integer = profiler.GetLengthFrequencyCount(columnNameStr);

GetNextLengthFrequency

This function steps to the next distinct length. It returns 1 if there are more distinct lengths or 0 when there are no more lengths.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the next distinct length.

Syntax	profiler->GetNextLengthFrequency(ColumnNameStr);
C	integer = mdProfilerGetNextLengthFrequency(profiler,columnNameStr);
.Net	integer = profiler.GetNextLengthFrequency(columnNameStr);