Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

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. Anchor
    Text_Layout
    Text_Layout
    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 NameDescription
    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 separatorA Column Separator used to separate columns. The available options are Tab, Comma, and Other. Select Other to provide other Column Separator. 
    Record separatorA Record Separator used to separate records. The available option is \n for new line. Select Other to provide other Record Separator.
    Upload Sample FileFile path to define the Text layout.
    Field definitionStructure 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.


    Anchor
    Structure_Manualy
    Structure_Manualy
    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.