Profiler Object:Column-Based Word Length Table Iteration

← Profiler Object Reference

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

StartWordLengthFrequency

This function initiates the iterator.

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	profiler->StartWordLengthFrequency(columnNameStr, Order);
C	mdProfilerStartWordLengthFrequency(profiler,columnNameStr, Order);
.Net	profiler.StartWordLengthFrequency(columnNameStr, Order);

GetWordLengthFrequencyValue

This function returns a column's distinct word length.

This function takes one parameter.

Parameters

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

Syntax	profiler->GetWordLengthFrequencyValue(columnNameStr);
C	string = mdProfilerGetWordLengthFrequencyValue(profiler,columnNameStr);
.Net	string = profiler.GetWordLengthFrequencyValue(columnNameStr);

GetWordLengthFrequencyCount

This function returns the number of times the word 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 word length appears in the profiled data.

Syntax	profiler->GetWordLengthFrequencyCount(columnNameStr);
C	integer = mdProfilerGetWordLengthFrequencyCount(profiler,columnNameStr);
.Net	integer = profiler.GetWordLengthFrequencyCount(columnNameStr);

GetNextWordLengthFrequency

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

This function takes one parameter.

Parameters

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

Syntax	profiler->GetNextWordLengthFrequency(columnNameStr);
C	integer = mdProfilerGetNextWordLengthFrequency(profiler,columnNameStr);
.Net	integer = profiler.GetNextWordLengthFrequency(columnNameStr);