Profiler Object:Function List

← 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