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.

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 Image RemovedImage Added to create a JSON layout from the source data layout.
    Image Removed

    Image Added

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

  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.

     

    Image RemovedImage Added

     

  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.
    Image Removed
    Image Added

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

     

  11. Click Save to save the selected column attribute.

  12. Click Save to save the Positional layout.