Home | Table of Contents | Record Pane | CloverETL 4.6.1
--- | --- | ---
Prev | Metadata Editor | Next

### Record Pane

Record pane displays an overview of the record as a whole and all its fields.

##### Record Overview

The first row presents an overview of the whole record.

It consists of the following columns:

- The name of the record is displayed in the second column and can be changed there.

- The type of the record is displayed in the third column and can be selected as delimited, fixed or mixed.

- The default delimiter defines character or characters separating each field from the following one (except for the last one). It is available in delimited and mixed records.

- The size is a size of the whole record. It is available in fixed-length metadata.

- The last column is always the label. It is similar to the field name, but there are no restrictions relating to it. See Field Name vs. Label vs. Description.

##### List of Records Fields

The other rows except the last one present the list of the record fields:

- The first column displays the number of the field. Fields are numbered starting from `1`.

- The second column displays the name of the field. It can be changed there. We suggest you only use the following characters for the field names: `[a-zA-Z0-9_]`.

- The third column displays the data type of the field. One of the data types for metadata can be selected. See Data Types in Metadata for more information.

- The other columns display the delimiter which follows the field displayed in the row, the size of the field or both the delimiter and size. If the delimiter is displayed greyish, it is the default delimiter, if it is black, it is non-default delimiter.

The last row presenting the last field slightly differs:

- The first three columns are the same as those in other field rows.

- The other columns display record delimiter which follows the last field (if it is displayed greyish) or the non-default delimiter which follows the last field and precedes the record delimiter (if it is displayed black), the size of the field or both the delimiter and size.

For detailed information about delimiters see Changing and Defining Delimiters.

##### Buttons for Record Modification

Several button necessary for modification of the record structure are placed on the left side of Record pane.

- Add field

- Remove field

- Move to top

- Move up

- Move down

- Move to bottom

- Print field value into log with token status - adds item into Key fields. This button is available in jobflow only. See Trackable Fields Selection.

- Do not print field value into log with token status - removes item from list in Key field. This option exclusive with the previous one. the button is available in jobflow only.

##### Filter

Filter in the bottom of Record pane enables user to filter displayed fields of the record. The filter expression is case-insensitive.

| Note
Each column of the Record pane can be sorted in ascending or descending order by simple clicking its header.

Prev | Up | Next
Basics of Metadata Editor | Home | Table of Contents | Field Name vs. Label vs. Description