Profiler Object:Data Input

From Melissa Data Wiki
Revision as of 02:26, 7 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
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
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
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

For each record to be profiled, call SetColumn or SetColumnNull for each column. After the values for all columns have been specified, call AddRecord to submit the record for profiling. Note that if SetColumn or SetColumnNull are called more than once for the same column before AddRecord is called, then the last function call's data will be used. Also, if neither SetColumn nor SetColumnNull are called before AddRecord, then the column is assumed to contain a NULL (i.e., the same as if you called SetColumnNull for that column.)


This function sets the value of the specific column.

This function takes two parameters.


Name Data Type Description
ColumnName String Column Name to set the value.
ColumnValue String Value for a specified column.

Syntax profiler->SetColumn(columnNameStr, valueString);
C mdProfilerSetColumn(profiler, ColumnName, ColumnValue);
.Net profiler.SetColumnSize(ColumnName, ColumnValue);


This function sets the Null value of the specific column.

This function takes one parameters.


Name Data Type Description
ColumnName String Column Name to set the value to NULL.

Syntax profiler->SetColumnNull(ColumnName);
C mdProfilerSetColumnNull(profiler, ColumnName);
.Net profiler.SetColumnNull(ColumnName);


This function submits the record’s column values for profiling. No Parameters are required. After calling AddRecord, the result for the current record will be available using GetResults.

Syntax profiler->AddRecrod();
C mdProfilerAddRecord(profiler);
.Net profiler.AddRecord();


This function retrieves result codes for each column in the submitted record. This should be called after AddRecord.

This function accepts one Parameter.


Name Data Type Description
ColumnName String Column Name to get the result codes.

Return Value

This returns a result codes specific to a column in string format.

Syntax profiler->GetResults(ColumnName);
C resultStr = mdProfilerGetResults(profiler, columnstr);
.Net resultStr = profiler.GetResults(columnstr);