Profiler Object:Function List: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 18: Line 18:
|-
|-
|[[Profiler Object:Initialization#SetUserName|SetUserName]]
|[[Profiler Object:Initialization#SetUserName|SetUserName]]
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Initialization#GetUserName|GetUserName]]
|[[Profiler Object:Initialization|Initialization]]
|[[Profiler Object:Initialization|Initialization]]
|-
|-
|[[Profiler Object:Initialization#SetTableName|SetTableName]]
|[[Profiler Object:Initialization#SetTableName|SetTableName]]
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Initialization#GetTableName|GetTableName]]
|[[Profiler Object:Initialization|Initialization]]
|[[Profiler Object:Initialization|Initialization]]
|-
|-
|[[Profiler Object:Initialization#SetJobName|SetJobName]]
|[[Profiler Object:Initialization#SetJobName|SetJobName]]
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Initialization#GetJobName|GetJobName]]
|[[Profiler Object:Initialization|Initialization]]
|[[Profiler Object:Initialization|Initialization]]
|-
|-
|[[Profiler Object:Initialization#SetJobDescription|SetJobDescription]]
|[[Profiler Object:Initialization#SetJobDescription|SetJobDescription]]
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Initialization#GetJobDescription|GetJobDescription]]
|[[Profiler Object:Initialization|Initialization]]
|[[Profiler Object:Initialization|Initialization]]
|-
|-
Line 54: Line 66:
|-
|-
|[[Profiler Object:Object Information#GetLicenseExpirationDate|GetLicenseExpirationDate]]
|[[Profiler Object:Object Information#GetLicenseExpirationDate|GetLicenseExpirationDate]]
|[[Profiler Object:Object Information|Object Information]]
|-
|[[Profiler Object:Object Information#GetProfileStartDateTime|GetProfileStartDateTime]]
|[[Profiler Object:Object Information|Object Information]]
|-
|[[Profiler Object:Object Information#GetProfileEndDateTime|GetProfileEndDateTime]]
|[[Profiler Object:Object Information|Object Information]]
|[[Profiler Object:Object Information|Object Information]]
|-
|-
Line 105: Line 123:
|-
|-
|[[Profiler Object:Column Specification#SetColumnScale|SetColumnScale]]
|[[Profiler Object:Column Specification#SetColumnScale|SetColumnScale]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#SetColumnIgnoreOnError|SetColumnIgnoreOnError]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnCount|GetColumnCount]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnName|GetColumnName]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnColumnType|GetColumnColumnType]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnDataType|GetColumnDataType]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnSize|GetColumnSize]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnPrecision|GetColumnPrecision]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnScale|GetColumnScale]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnValueRangeFrom|GetColumnValueRangeFrom]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnValueRangeTo|GetColumnValueRangeTo]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnDefaultValue|GetColumnDefaultValue]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Column Specification#GetColumnCustomPatterns|GetColumnCustomPatterns]]
|[[Profiler Object:Column Specification|Column Specification]]
|[[Profiler Object:Column Specification|Column Specification]]
|-
|-
Line 117: Line 171:
|-
|-
|[[Profiler Object:Data Input#AddRecord|AddRecord]]
|[[Profiler Object:Data Input#AddRecord|AddRecord]]
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Data Input#AddDelimitedRecord|AddDelimitedRecord]]
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Data Input#GetColumnValue|GetColumnValue]]
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Data Input#SetColumnDelimiter|SetColumnDelimiter]]
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Data Input#SetRowDelimiter|SetRowDelimiter]]
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Data Input#SetTextQualifier|SetTextQualifier]]
|[[Profiler Object:Data Input|Data Input]]
|[[Profiler Object:Data Input|Data Input]]
|-
|-
Line 170: Line 239:
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnColumnType|GetColumnColumnType]]
|[[Profiler Object:Table-Based Statistics#GetTableEmbeddedRowDelimiterCount|GetTableEmbeddedRowDelimiterCount]]
|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnDataType|GetColumnDataType]]
|[[Profiler Object:Table-Based Statistics#GetTableNotAllFieldsPresentCount|GetTableNotAllFieldsPresentCount]]
|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnSize|GetColumnSize]]
|[[Profiler Object:Table-Based Statistics#GetTableExtraFieldsPresentCount|GetTableExtraFieldsPresentCount]]
|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnPrecision|GetColumnPrecision]]
|[[Profiler Object:Table-Based Statistics#GetTableUnbalancedTextQualifiersCount|GetTableUnbalancedTextQualifiersCount]]
|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnScale|GetColumnScale]]
|[[Profiler Object:Table-Based Statistics#GetTableUnescapedEmbeddedTextQualifiersCount|GetTableUnescapedEmbeddedTextQualifiersCount]]
|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based Statistics#GetColumnInferredDataType|GetColumnInferredDataType]]
|[[Profiler Object:Column-Based Statistics#GetColumnInferredDataType|GetColumnInferredDataType]]
Line 486: Line 555:
|-
|-
|[[Profiler Object:Column-Based Zip/Postal Code Statistics#GetColumnZipCodePostalCodeInvalidCount|GetColumnZipCodePostalCodeInvalidCount]]
|[[Profiler Object:Column-Based Zip/Postal Code Statistics#GetColumnZipCodePostalCodeInvalidCount|GetColumnZipCodePostalCodeInvalidCount]]
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|-
|[[Profiler Object:Column-Based Zip/Postal Code Statistics#GetColumnStateZipCodeMismatchCount|GetColumnStateZipCodeMismatchCount]]
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|-
|[[Profiler Object:Column-Based Zip/Postal Code Statistics#GetColumnProvincePostalCodeMismatchCount|GetColumnProvincePostalCodeMismatchCount]]
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|-
|-

Latest revision as of 23:59, 14 May 2015

← Profiler Object Reference

Function Name Group
SetLicenseString Initialization
SetPathToProfilerDataFiles Initialization
SetFileName Initialization
SetAppendMode Initialization
SetUserName Initialization
GetUserName Initialization
SetTableName Initialization
GetTableName Initialization
SetJobName Initialization
GetJobName Initialization
SetJobDescription Initialization
GetJobDescription Initialization
SetSortAnalysis Initialization
SetMatchUpAnalysis Initialization
SetRightFielderAnalysis Initialization
SetDataAggregation Initialization
InitializeDataFiles Initialization
GetInitializeErrorString Initialization
GetBuildNumber Object Information
GetDatabaseDate Object Information
GetLicenseExpirationDate Object Information
GetProfileStartDateTime Object Information
GetProfileEndDateTime Object Information
GetColumnTypeEnum Enumeration Listing and Parsing
GetColumnTypeDescription Enumeration Listing and Parsing
ParseColumnTypeDescription Enumeration Listing and Parsing
GetDataTypeEnum Enumeration Listing and Parsing
GetDataTypeDescription Enumeration Listing and Parsing
ParseDataTypeDescription Enumeration Listing and Parsing
GetResultCodeEnum Enumeration Listing and Parsing
GetResultCodeDescription Enumeration Listing and Parsing
ProfilerColumnType Enumerations Enumeration Listing and Parsing
ProfilerDataType Enumerations Enumeration Listing and Parsing
AddColumn Column Specification
SetColumnCustomPattern Column Specification
SetColumnValueRange Column Specification
SetColumnDefaultValue Column Specification
SetColumnSize Column Specification
SetColumnPrecision Column Specification
SetColumnScale Column Specification
SetColumnIgnoreOnError Column Specification
GetColumnCount Column Specification
GetColumnName Column Specification
GetColumnColumnType Column Specification
GetColumnDataType Column Specification
GetColumnSize Column Specification
GetColumnPrecision Column Specification
GetColumnScale Column Specification
GetColumnValueRangeFrom Column Specification
GetColumnValueRangeTo Column Specification
GetColumnDefaultValue Column Specification
GetColumnCustomPatterns Column Specification
StartProfiling Initiate Profiling
SetColumn Data Input
SetColumnNull Data Input
AddRecord Data Input
AddDelimitedRecord Data Input
GetColumnValue Data Input
SetColumnDelimiter Data Input
SetRowDelimiter Data Input
SetTextQualifier Data Input
GetResults Data Input
ProfileData Profiling
GetTableRecordCount Table-Based Statistics
GetTableRecordEmptyCount Table-Based Statistics
GetTableRecordNullCount Table-Based Statistics
GetTableExactMatchDistinctCount Table-Based Statistics
GetTableExactMatchDupesCount Table-Based Statistics
GetTableExactMatchLargestGroup Table-Based Statistics
GetTableContactMatchDistinctCount Table-Based Statistics
GetTableContactMatchDupesCount Table-Based Statistics
GetTableContactMatchLargestGroup Table-Based Statistics
GetTableHouseholdMatchDistinctCount Table-Based Statistics
GetTableHouseholdMatchDupesCount Table-Based Statistics
GetTableHouseholdMatchLargestGroup Table-Based Statistics
GetTableAddressMatchDistinctCount Table-Based Statistics
GetTableAddressMatchDupesCount Table-Based Statistics
GetTableAddressMatchLargestGroup Table-Based Statistics
GetTableEmbeddedRowDelimiterCount Table-Based Statistics
GetTableNotAllFieldsPresentCount Table-Based Statistics
GetTableExtraFieldsPresentCount Table-Based Statistics
GetTableUnbalancedTextQualifiersCount Table-Based Statistics
GetTableUnescapedEmbeddedTextQualifiersCount Table-Based Statistics
GetColumnInferredDataType Column-Based Statistics
GetColumnSortation Column-Based Statistics
GetColumnSortationPercent Column-Based Statistics
GetColumnMostPopularCount Column-Based Statistics
GetColumnDistinctCount Column-Based Statistics
GetColumnUniqueCount Column-Based Statistics
GetColumnDefaultValueCount Column-Based Statistics
GetColumnBelowRangeCount Column-Based Statistics
GetColumnAboveRangeCount Column-Based Statistics
GetColumnAboveSizeCount Column-Based Statistics
GetColumnAbovePrecisionCount Column-Based Statistics
GetColumnAboveScaleCount Column-Based Statistics
GetColumnInvalidRegExCount Column-Based Statistics
GetColumnEmptyCount Column-Based Statistics
GetColumnNullCount Column-Based Statistics
GetColumnInvalidDataCount Column-Based Statistics
GetColumnInvalidUTF8Count Column-Based Statistics
GetColumnNonPrintingCharCount Column-Based Statistics
GetColumnDiacriticCharCount Column-Based Statistics
GetColumnForeignCharCount Column-Based Statistics
GetColumnAlphaOnlyCount Column-Based Statistics
GetColumnNumericOnlyCount Column-Based Statistics
GetColumnAlphaNumericCount Column-Based Statistics
GetColumnUpperCaseOnlyCount Column-Based Statistics
GetColumnLowerCaseOnlyCount Column-Based Statistics
GetColumnMixedCaseCount Column-Based Statistics
GetColumnSingleSpaceCount Column-Based Statistics
GetColumnMultiSpaceCount Column-Based Statistics
GetColumnLeadingSpaceCount Column-Based Statistics
GetColumnTrailingSpaceCount Column-Based Statistics
GetColumnMaxSpaces Column-Based Statistics
GetColumnMinSpaces Column-Based Statistics
GetColumnTotalSpaces Column-Based Statistics
GetColumnTotalWordBreaks Column-Based Statistics
GetColumnAvgSpaces Column-Based Statistics
GetColumnDecorationCharCount Column-Based Statistics
GetColumnProfanityCount Column-Based Statistics
GetColumnInconsistentDataCount Column-Based Statistics
GetColumnStringMaxValue Column-Based String Statistics
GetColumnStringMinValue Column-Based String Statistics
GetColumnStringQ1Value Column-Based String Statistics
GetColumnStringMedValue Column-Based String Statistics
GetColumnStringQ3Value Column-Based String Statistics
GetColumnStringMaxLength Column-Based String Statistics
GetColumnStringMinLength Column-Based String Statistics
GetColumnStringAvgLength Column-Based String Statistics
GetColumnStringQ1Length Column-Based String Statistics
GetColumnStringMedLength Column-Based String Statistics
GetColumnStringQ3Length Column-Based String Statistics
GetColumnWordMaxValue Column-Based String Statistics
GetColumnWordMinValue Column-Based String Statistics
GetColumnWordQ1Value Column-Based String Statistics
GetColumnWordMedValue Column-Based String Statistics
GetColumnWordQ3Value Column-Based String Statistics
GetColumnWordMaxLength Column-Based String Statistics
GetColumnWordMinLength Column-Based String Statistics
GetColumnWordAvgLength Column-Based String Statistics
GetColumnWordQ1Length Column-Based String Statistics
GetColumnWordMedLength Column-Based String Statistics
GetColumnWordQ3Length Column-Based String Statistics
GetColumnMaxWords Column-Based String Statistics
GetColumnMinWords Column-Based String Statistics
GetColumnAvgWords Column-Based String Statistics
GetColumnNumericMaxValue Column-Based Numeric Statistics
GetColumnNumericMinValue Column-Based Numeric Statistics
GetColumnNumericAvgValue Column-Based Numeric Statistics
GetColumnNumericQ1Value Column-Based Numeric Statistics
GetColumnNumericQ1IntValue Column-Based Numeric Statistics
GetColumnNumericMedValue Column-Based Numeric Statistics
GetColumnNumericMedIntValue Column-Based Numeric Statistics
GetColumnNumericQ3Value Column-Based Numeric Statistics
GetColumnNumericQ3IntValue Column-Based Numeric Statistics
GetColumnNumericStdDevValue Column-Based Numeric Statistics
GetColumnDateMaxValue Column-Based Date/Time Statistics
GetColumnDateMinValue Column-Based Date/Time Statistics
GetColumnDateAvgValue Column-Based Date/Time Statistics
GetColumnDateQ1Value Column-Based Date/Time Statistics
GetColumnDateMedValue Column-Based Date/Time Statistics
GetColumnDateQ3Value Column-Based Date/Time Statistics
GetColumnTimeMaxValue Column-Based Date/Time Statistics
GetColumnTimeMinValue Column-Based Date/Time Statistics
GetColumnTimeAvgValue Column-Based Date/Time Statistics
GetColumnTimeQ1Value Column-Based Date/Time Statistics
GetColumnTimeMedValue Column-Based Date/Time Statistics
GetColumnTimeQ3Value Column-Based Date/Time Statistics
GetColumnDateNoCenturyCount Column-Based Date/Time Statistics
GetColumnNameInconsistentOrderCount Column-Based Name Statistics
GetColumnNameMultipleNameCount Column-Based Name Statistics
GetColumnNameSuspiciousNameCount Column-Based Name Statistics
GetColumnStateCount Column-Based State/Province Statistics
GetColumnProvinceCount Column-Based State/Province Statistics
GetColumnStateProvinceNonStandardCount Column-Based State/Province Statistics
GetColumnStateProvinceInvalidCount Column-Based State/Province Statistics
GetColumnStateZipCodeMismatchCount Column-Based State/Province Statistics
GetColumnProvincePostalCodeMismatchCount Column-Based State/Province Statistics
GetColumnZipCodeCount Column-Based Zip/Postal Code Statistics
GetColumnPlus4Count Column-Based Zip/Postal Code Statistics
GetColumnZipCodeInvalidCount Column-Based Zip/Postal Code Statistics
GetColumnPostalCodeCount Column-Based Zip/Postal Code Statistics
GetColumnPostalCodeInvalidCount Column-Based Zip/Postal Code Statistics
GetColumnZipCodePostalCodeInvalidCount Column-Based Zip/Postal Code Statistics
GetColumnStateZipCodeMismatchCount Column-Based Zip/Postal Code Statistics
GetColumnProvincePostalCodeMismatchCount Column-Based Zip/Postal Code Statistics
GetColumnCountryNonStandardCount Column-Based Country Statistics
GetColumnCountryInvalidCount Column-Based Country Statistics
GetColumnEmailSyntaxCount Column-Based Email Statistics
GetColumnEmailMobileDomainCount Column-Based Email Statistics
GetColumnEmailMisspelledDomainCount Column-Based Email Statistics
GetColumnEmailSpamtrapDomainCount Column-Based Email Statistics
GetColumnEmailDisposableDomainCount Column-Based Email Statistics
GetColumnPhoneInvalidCount Column-Based Phone Statistics
StartDataFrequency Column-Based Value Frequency Table Iteration
GetDataFrequencyValue Column-Based Value Frequency Table Iteration
GetDataFrequencyCount Column-Based Value Frequency Table Iteration
GetNextDataFrequency Column-Based Value Frequency Table Iteration
StartLengthFrequency Column-Based Value Length Frequency Table Iteration
GetLengthFrequencyValue Column-Based Value Length Frequency Table Iteration
GetLengthFrequencyCount Column-Based Value Length Frequency Table Iteration
GetNextLengthFrequency Column-Based Value Length Frequency Table Iteration
StartPatternFrequency Column-Based Value Pattern Table Iteration
GetPatternFrequencyValue Column-Based Value Pattern Table Iteration
GetPatternFrequencyRegEx Column-Based Value Pattern Table Iteration
GetPatternFrequencyExample Column-Based Value Pattern Table Iteration
GetPatternFrequencyCount Column-Based Value Pattern Table Iteration
GetNextPatternFrequency Column-Based Value Pattern Table Iteration
StartDateFrequency Column-Based Value Date/Time Table Iteration
GetDateFrequencyValue Column-Based Value Date/Time Table Iteration
GetDateFrequencyCount Column-Based Value Date/Time Table Iteration
GetNextDateFrequency Column-Based Value Date/Time Table Iteration
StartSoundExFrequency Column-Based Value SoundEx Table Iteration
GetSoundExFrequencyValue Column-Based Value SoundEx Table Iteration
GetSoundExFrequencyExample Column-Based Value SoundEx Table Iteration
GetSoundExFrequencyCount Column-Based Value SoundEx Table Iteration
GetNextSoundExFrequency Column-Based Value SoundEx Table Iteration
StartWordFrequency Column-Based Word Table Iteration
GetWordFrequencyValue Column-Based Word Table Iteration
GetWordFrequencyCount Column-Based Word Table Iteration
GetNextWordFrequency Column-Based Word Table Iteration
StartWordLengthFrequency Column-Based Word Length Table Iteration
GetWordLengthFrequencyValue Column-Based Word Length Table Iteration
GetWordLengthFrequencyCount Column-Based Word Length Table Iteration
GetNextWordLengthFrequency Column-Based Word Length Table Iteration


Category:Profiler Object

Retrieved from "http://wiki.melissadata.com/index.php?title=Profiler_Object:Function_List&oldid=8751"