Difference between revisions of "Profiler Object:Data Input"

From Melissa Data Wiki
Jump to navigation Jump to search
Line 110: Line 110:
This function sets the Null value of the specific column.
This function sets the Null value of the specific column.


This function takes one parameters.
This function takes one parameter.


===Parameters===
===Parameters===

Revision as of 18:42, 2 February 2015

← 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


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.)

SetColumn

This function sets the value of the specific column.

This function takes two parameters.

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);


SetColumnNull

This function sets the Null value of the specific column.

This function takes one parameter.

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);


AddRecord

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();


GetResults

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

This function accepts one Parameter.

Parameters

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);