Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Using the Positional layout, you can define the structure of your Fixed Length file either at Source or Destination. You need to specify the names and the positions of required fields in order to identify these fields.

To create a Positional layout:

  1. Select Positional from the Source data format drop-down list.
  2. Click  to create a JSON layout from the source data layout.



  3. Anchor
    Positional_Layout
    Positional_Layout
    On the Create Layout window, provide the name of the Positional layout.



  4. Click Next to upload a sample Positional file.
  5. Click Browse to upload a sample Positional file that you want to use for defining the Source or Destination structure.

  6. Drag the column edge to re-size the width of each column as per the required character length.

    Info
    If you need column headers, click the default column names to change them manually. In addition, the column width is also not automatically adjusted as per the uploaded sample file. You need to re-size the width of each column manually.

     


     

  7. You may click each column to modify the default names in the Column field.
  8. Click the column header of the required column to edit, insert, split, or delete it.
  9. Select Column Attribute to choose the data type for each column.



  10.  Choose the type, alignment, and description for values of each column.

     

  11. Click Save to save the selected column attribute.

  12. Click Save to save the Positional layout.