|
|
| Line 2: |
Line 2: |
| [[Profiler Object:Reference|← Profiler Object Reference]] | | [[Profiler Object:Reference|← Profiler Object Reference]] |
|
| |
|
| {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;" | | {{ProfilerObjectNav |
| ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
| | |IteratorsCollapse= |
| |-
| | }} |
| | style="padding-right:220px;"|
| |
| |-
| |
| |[[Profiler Object:Initialization|Initialization]]
| |
| |-
| |
| |[[Profiler Object:Object Information|Object Information]]
| |
| |-
| |
| |[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
| |
| |-
| |
| |[[Profiler Object:Column Specification|Column Specification]]
| |
| |-
| |
| |[[Profiler Object:Initiate Profiling|Initiate Profiling]]
| |
| |-
| |
| |[[Profiler Object:Data Input|Data Input]]
| |
| |-
| |
| |[[Profiler Object:Profiling|Profiling]]
| |
| |-
| |
| |[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
| |
| |-
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;" | |
| |- align="left" | |
| ! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
| |
| |-
| |
| |[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
| |
| |-
| |
| |[[Result Codes]]
| |
| |}
| |
| |}
| |
|
| |
|
|
| |
|
| Line 121: |
Line 46: |
| {{Object Syntax | | {{Object Syntax |
| |Syntax=profiler->GetDataFrequencyValue(columnNameStr); | | |Syntax=profiler->GetDataFrequencyValue(columnNameStr); |
| |C=string = mdProfilerGetDataFrequencyValue(profiler,columnNameStr); | | |C=const char* = mdProfilerGetDataFrequencyValue(profiler,columnNameStr); |
| |.Net=string = profiler.GetDataFrequencyValue(columnNameStr); | | |.Net=string = profiler.GetDataFrequencyValue(columnNameStr); |
| }} | | }} |
← Profiler Object Reference
These functions allow you to step through each distinct value for a specific column.
StartDataFrequency
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->StartDataFrequency(columnNameStr, Order);
|
| C
|
mdProfilerStartDataFrequency(profiler,columnNameStr, Order);
|
| .Net
|
profiler.StartDataFrequency(columnNameStr, Order);
|
GetDataFrequencyValue
This function returns a column's distinct value.
This function takes one parameter.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to get the column’s distinct value.
|
| Syntax
|
profiler->GetDataFrequencyValue(columnNameStr);
|
| C
|
const char* = mdProfilerGetDataFrequencyValue(profiler,columnNameStr);
|
| .Net
|
string = profiler.GetDataFrequencyValue(columnNameStr);
|
GetDataFrequencyCount
This function returns the number of times the value appeared 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 value appeared in the profiled data.
|
| Syntax
|
profiler->GetDataFrequencyCount(columnNameStr);
|
| C
|
integer = mdProfilerGetDataFrequencyCount(profiler,columnNameStr);
|
| .Net
|
integer = profiler.GetDataFrequencyCount(columnNameStr);
|
GetNextDataFrequency
This function steps to the next distinct value. It returns 1 if there are more distinct values and 0 when there are no more values.
This function takes one parameter.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to get the next distinct value.
|
| Syntax
|
profiler->GetNextDataFrequency(columnNameStr);
|
| C
|
integer = mdProfilerGetNextDataFrequency(profiler,columnNameStr);
|
| .Net
|
integer = profiler.GetNextDataFrequency(columnNameStr);
|