FieldInTableProfilingData
Properties
Name | Description | Type |
---|---|---|
qName |
Name of the field. |
String |
qFieldTags |
List of tags related to the field. |
Array of String |
qNumberFormat |
Sets the formatting of a field. The properties of qFieldAttributes and the formatting mechanism are described below. Formatting mechanismThe formatting mechanism depends on the type set in qType, as shown below: Information note
In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type. Type is DATE, TIME, TIMESTAMP or INTERVALThe following applies:
Type is INTEGERThe following applies:
Type is REALThe following applies:
Type is FIXThe following applies:
Type is MONEYThe following applies:
Type is ASCIINo formatting, qFmt is ignored. |
FieldAttributes |
qDistinctValues |
Number of distinct values |
Integer |
qDistinctNumericValues |
Number of distinct numeric values |
Integer |
qDistinctTextValues |
Number of distinct text values |
Integer |
qNumericValues |
Number of numeric values |
Integer |
qNullValues |
Number of null values |
Integer |
qTextValues |
Number of textual values |
Integer |
qNegValues |
Number of negative values |
Integer |
qPosValues |
Number of positive values |
Integer |
qZeroValues |
Number of zero values for numerical values |
Integer |
qSum |
Sum of all numerical values. NaN otherwise. |
Number (double) |
qSum2 |
Squared sum of all numerical values. NaN otherwise. |
Number (double) |
qAverage |
Average of all numerical values. NaN otherwise. |
Number (double) |
qMedian |
Median of all numerical values. NaN otherwise. |
Number (double) |
qStd |
Standard deviation of numerical values. NaN otherwise. |
Number (double) |
qMin |
Minimum value of numerical values. NaN otherwise. |
Number (double) |
qMax |
Maximum value of numerical values. NaN otherwise. |
Number (double) |
qSkewness |
Skewness of the numerical values. NaN otherwise. |
Number (double) |
qKurtosis |
Kurtosis of the numerical values. NaN otherwise. |
Number (double) |
qFractiles |
The .01, .05, .1, .25, .5, .75, .9, .95, .99 fractiles. Array of NaN otherwise. |
Array of Number |
qEmptyStrings |
Number of empty strings |
Integer |
qMaxStringLen |
Maximum string length of textual values. 0 otherwise. |
Integer |
qMinStringLen |
Minimum string length of textual values. 0 otherwise. |
Integer |
qSumStringLen |
Sum of all characters in strings in the field |
Integer |
qAvgStringLen |
Average string length of textual values. 0 otherwise. |
Number (double) |
qFirstSorted |
For textual values the first sorted string. |
String |
qLastSorted |
For textual values the last sorted string. |
String |
qMostFrequent |
Three most frequent values and their frequencies |
Array of SymbolFrequency |
qFrequencyDistribution | FrequencyDistributionData |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!