Profiler Object:Column-Based Value Length Frequency Table Iteration
Revision as of 00:16, 10 January 2015 by Admin (talk | contribs) (Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size...")
These functions allow you to step through each distinct value length for a specific column.
StartLengthFrequency
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->StartLengthFrequency(columnNameStr, Order); |
---|---|
C | mdProfilerStartLengthFrequency(profiler,columnNameStr, Order); |
.Net | 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); |