The contents of the Details pane changes in accordance with the row selected in the Record pane.
If you select the first row, details about the whole record are displayed.
See Record Details.
If you select other row, details about the selected field are displayed.
See Field Details.
When the Details pane presents information about the record as a whole, there are displayed its properties.
Basic properties are the following:
Name. This is the name of the record. It can be changed there.
Type. This is the type of the
record. One of the following three can be selected:
delimited
, fixed
,
mixed
. See Record Types for more
information.
Record delimiter. This is the delimiter following the last field meaning the end of the record. It can be changed there. If the delimiter in the last row of the Record pane in its Delimiter column is displayed greyish, it is this record delimiter. If it is black, it is other, non-default delimiter defined for the last field which follows it and precedes the record delimiter.
See Changing and Defining Delimiters for more detailed information.
Record size. Displayed for
fixed
or mixed
record
type only. This is the length of the record counted in number
of characters. It can be changed there.
Default delimiter. Displayed for
delimited
or mixed
record type only. This is the delimiter following by default
each field of the record except the last one. It can be
changed there. This delimiter is displayed in each other row
(except the last one) of the Record pane
in its Delimiter column if it is greyish.
If it is black, it is other, non-default delimiter defined for
such a field which overrides the default one and is used
instead of it.
See Changing and Defining Delimiters for more detailed information.
Skip source rows. This is the
number of records that will be skipped for each input file. If
an edge with this attribute is connected to a
Reader, this value overrides the default
value of the Number of skipped records per
source attribute, which is 0
. If
the Number of skipped records per source
attribute is not specified, this number of records are skipped
from each input file. If the attribute in the
Reader is set to any value, it overrides
this property value. Remember that these two values are not
summed.
Description. This property describes the meaning of the record.
Advanced properties are the following:
Locale. This is the locale that is used for the whole record. This property can be useful for date formats or for decimal separator, for example. It can be overriden by the Locale specified for individual field.
See Locale for detailed information.
Locale sensitivity. Applied for the whole record.
It can be overriden by the Locale sensitivity specified for individual field (of string
data type).
See Locale Sensitivity for detailed information.
Null value. This property is set for the whole record.
It is used to specify what values of fields should be processed as
null
. By default, empty field or empty
string (""
) are processed as
null
. You can set this property value to
any string of characters that should be interpreted as
null
. All of the other string values remain
unchanged. If you set this property to any non-empty string,
empty string or empty field value will remain to be empty
string (""
).
It can be overriden by the value of Null value property of individual field.
Preview attachment. This is the file URL of the file attached to the metadata. It can be changed there or located using the button.
Preview Charset. This is the charset of the file attached to the metadata. It can be changed there or by selecting from the combobox.
Preview Attachment Metadata Row. This is the number of the row of the attached file where record field names are located.
Preview Attachment Sample Data Row. This is the number of the row of the attached file from where field data types are guessed.
Also Custom properties can be defined by clicking the sign button. For example, these properties can be the following:
charset. This is the charset of the record. For example, when metadata are extracted from dBase files, these properties may be displayed.
dataOffset. Displayed for
fixed
or mixed
record
type only.
When the Details pane presents information about a field, there are displayed its properties.
Basic properties are the following:
Name. This is the same field name as in the Record pane.
Type. This is the same data type as in the Record pane.
See Data Types and Record Types for more detailed information.
Delimiter. This is the non-default field delimiter as in the Record pane. If it is empty, default delimiter is used instead.
See Changing and Defining Delimiters for more detailed information.
Size. This is the same size as in the Record pane.
Nullable. This can be
true
or false
. The
default value is true
. In such a case, the
field value can be null. Otherwise, null values are prohibited
and graph fails if null is met.
Default. This is the default value
of the field. It is used if you set the
Autofilling property to
default_value
.
See Autofilling Functions for more detailed information.
Length. Displayed for
decimal
data type only. For
decimal
data types you can optionally
define its length. It is the maximum number of digits in this
number. The default value is 8
.
See Data Types and Record Types for more detailed information.
Scale. Displayed for
decimal
data type only. For
decimal
data types you can optionally
define scale. It is the maximum number of digits following the
decimal dot. The default value is 2
.
See Data Types and Record Types for more detailed information.
Description. This property describes the meaning of the selected field.
Advanced properties are the following:
Format. Format defining the parsing
and/or the formatting of a boolean
, date
,
decimal
, integer
, long
,
number
, and string
data field.
See Data Formats for more information.
Locale. This property can be useful for date formats or for decimal separator, for example. It overrides the Locale specified for the whole record.
See Locale for detailed information.
Locale sensitivity. Displayed for
string
data type only.
Is applied only if Locale is specified for the field or the whole record.
It overrides the Locale sensitivity specified for the whole record.
See Locale Sensitivity for detailed information.
Null value. This property can be set
up to specify what values of fields should be processed as
null
. By default, empty field or empty
string (""
) are processed as
null
. You can set this property value to
any string of characters that should be interpreted as
null
. All of the other string values remain
unchanged. If you set this property to any non-empty string,
empty string or empty field value will remain to be empty
string (""
).
It overrides the value of Null value property of the whole record.
Autofilling.
If defined, field marked as autofilling
is filled with a value by one of the functions listed in the Autofilling Functions section.
Shift. This is the gap between the end of one field and the start of the next one when the fields are part of fixed or mixed record and their sizes are set to some value.
EOF as delimiter. This can be set to true or false according to whether EOF character is used as delimiter. It can be useful when your file does not end with any other delimiter. If you did not set this property to true, run of the graph with such data file would fail (by default it is false). Displayed in delimited or mixed data records only.