Creating a Text Layout

You can use a Text file to define the structure of your Source or Destination layout. To create a Text file layout, you need to specify the format of the text file.

To create a Text file layout:

1. Select Text from the source data format drop-down list.
   
2. Click  to create a Text layout from the source data layout. 
   
   
   
   
3. On the Create Layout window, provide the name of the Text layout. 
   
   
   
   

4. Click Next to continue further.

5. Provide the details in the following fields.

   Field Name	Description
   File header present	File Header usually contains the titles of the fields in your Text file. In addition, if the Text layout is used at the destination, and the File header present check box is selected, the title will be included in the destination Text file. If you are configuring the layout at the Source application then on selecting the check box, a new field appears. If the position of the header field in the schema and the target file differ, click No. On selecting No, a new field appears. Click Yes if the header fields are case sensitive.
   Data field separator	A Column Separator used to separate columns. The available options are Tab, Comma, and Other. Select Other to provide other Column Separator.
   Record separator	A Record Separator used to separate records. The available option is \n for new line. Select Other to provide other Record Separator.
   Upload Sample File	File path to define the Text layout.
   Field definition	Structure of the sample Text layout file. When you select the sample Text layout file, the structure of the file is displayed in this table. By default, data type for each column is String. You can modify the column attributes/data types of the column by right clicking the column and selecting Column Attributes. Instead of uploading a sample file, you can also create the structure manually. To create the structure manually, click here.

   

   
   To create the table structure manually:

    

1. Click the column header to edit, insert, or delete columns, if required.

2. Select Column Attribute to choose the data type for each column.
   
   
   
   

3. Select the type for the column. 

4. Click Save to save the selected column attribute.
   
   

   
   

6. Click Save to save the Text layout.