Create a Text Layout with array fields

If you select the Array Fields Present checkbox on the Create New Text Layout screen, follow the steps outlined below:

1. On the Create New Text Layout screen, in the Record Separator field, provide the record separator, for example, \n for newline or " " for space or select from the list. The record separator is used to separate the records. 

2. In the Field Separator, provide the field separator, for example, \t for Tab or " " for space or select from the list. A Field Separator is used to separate fields.

3. Select the project from the Project drop-down list.

   By default, the Project drop-down box displays the default project of the logged-in user as the selected project.

4. Click Continue to define the records on the Record Definition screen.

5. In the Record Definition section, provide the name of the fields.

   Click either Add Row  to include a new row or Delete Row to remove a row from the record definition.

6. Select the type of data from the Data Type drop-down list.
   The supported data for text Layout are described in the following table:

   Data Type	Description
   String	Select this data type if the field contains a string value.
   Number	Select this data type if the field contains a numeric value.
   Date	Select this data type if the field contains a Date or Date and Time value.
   Number Array	Select this data type if the field contains values of numeric data type.
   String Array	Select this data type if the field contains values of string data type.
   Date Array	Select this data type if the field contains values of Date or Date and Time type.
   Composite Array	Select this data type if the field contains values in a combination of numeric, string, Date/Date, and Time data types.  If you select Composite Array as the data type for a field in the file, you need to define the subfields of the Composite Array field by following the steps given below: Click(Add Sub Fields) against the Composite Array field.  For the subfield, enter the name, data type (String, Number, or Date), and format (only if the selected data type is Date or Date and Time).  Similarly, define the other subfields.  Click  on the left of the Composite Array field to collapse the subfields.

7. Select the date and time format for the Date or Date Array data type in the Format and Sub Format fields respectively. These fields are applicable only for Date or Date Array data types.

8. In the Occurrence field, enter the number of array field values or sets of array field values. This field is applicable only for array data types.

9. Click Save to add the record definition.

   You can edit the Table Data by clicking Edit.   To collapse the record definition click .

10. Click Save Layout to save the Layout.