Profiler Object:Column-Based Value Date/Time Table Iteration

From Melissa Data Wiki
Revision as of 00:30, 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Returned Result Codes
Result Codes


These functions allow you to step through each distinct value date/time for a specific column. Date values are gathered for all column types, not just date/time data types.

StartDateFrequency

This function initiates the iterator.

This function takes three 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.
Date Span DateSpan You must specify a DateSpan - the resolution to be used when stepping through each value (e.g., date, month, year, etc).


Date Span Enumerations

Value Name Description
1 DateSpanDate Group by date
2 DateSpanTime Group by time
3 DateSpanHour Group by hour
4 DateSpanMinute Group by minute
5 DateSpanSecond Group by second
6 DateSpanMillisecond Group by millisecond
7 DateSpanDayOfWeek Group by day of the week
8 DateSpanDay Group by day of the month
9 DateSpanWeek Group by week of the year
10 DateSpanMonth Group by month
11 DateSpanQuarter Group by quarter
12 DateSpanYear Group by year
13 DateSpanDecade Group by decade
14 DateSpanCentury Group by century
Syntax profiler->StartDateFrequency(columnNameStr, Order, DateSpan);
C mdProfilerDateFrequency(profiler,columnNameStr, Order, DateSpan);
.Net profiler.StartDateFrequency(columnNameStr, Order, DateSpan);


GetDateFrequencyValue

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->GetDateFrequencyValue(columnNameStr);
C string = mdProfilerGetDateFrequencyValue(profiler,columnNameStr);
.Net string = profiler.GetDateFrequencyValue(columnNameStr);


GetDateFrequencyCount

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->GetDateFrequencyCount(columnNameStr);
C integer = mdProfilerGetDateFrequencyCount(profiler,columnNameStr);
.Net integer = profiler.GetDateFrequencyCount(columnNameStr);


GetNextDateFrequency

This function steps to the next distinct value. It returns 1 if there are more distinct values or 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->GetNextDateFrequency(columnNameStr);
C integer = mdProfilerGetNextDateFrequency(profiler,columnNameStr);
.Net integer = profiler.GetNextDateFrequency(columnNameStr);