FieldInTableData
Properties
| Name | Description | Type |
|---|---|---|
| qName |
Name of the field. |
String |
| qOriginalFields |
Is shown for fixed records. qOriginalFieldName and qName are identical if no field names are used in the file. qOriginalFieldName differs from qName if embedded file names are used in the file. |
Array of String |
| qPresent | Boolean | |
| qHasNull |
This property is set to true if the field contains some Null values. |
Boolean |
| qHasWild | Boolean | |
| qHasDuplicates |
This property is set to true if the field contains some duplicate values. |
Boolean |
| qIsSynthetic |
This property is set to true if the field contains a synthetic key. |
Boolean |
| qInformationDensity |
Number of records that have values (for example, not NULL) in the field as compared to the total number of records in the table. |
Number (double) |
| qnNonNulls |
Number of values that are non Null. |
Integer |
| qnRows |
Number of rows in the field. |
Integer |
| qSubsetRatio |
Number of distinct values in the field (in the current table) as compared to the total number of distinct values of this field (in all tables). |
Number (double) |
| qnTotalDistinctValues |
Number of distinct values in the field. |
Integer |
| qnPresentDistinctValues | Integer | |
| qKeyType |
Tells if the field is a key field. One of:
|
String |
| qComment |
Comment related to the field. |
String |
| qTags |
List of tags related to the field. |
Array of String |
| qDerivedFields |
List of the derived fields. |
Array of DerivedFieldsInTableData |
| qIsFieldOnTheFly | Boolean | |
| qReadableName | String |
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!