Skip to main content Skip to complementary content

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:

  • NOT_KEY
  • ANY_KEY
  • PRIMARY_KEY
  • PERFECT_KEY
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!