Configure the File tab details - Input stage

  1. At the File Name field, click the file name button to display the Choose File selection dialog.
    Flow Designer displays a list of available files at the default location.
  2. To select an input file, you can:
    • Go to another location using the navigation character (<).
    • Filter the list of files using a letter or string then clicking the filter button.
    • Click a to select a file name in the scroll box, and click OK to confirm your choice.
    Flow Designer returns to the Read From File configuration page File tab, displaying your input file in the File Name field.
  3. Review the populated File tab fields to ensure correctness and make adjustments if needed.
  4. Check the boxes that provide more detail on the file content:
    • First row is header record – Toggle to YES if the first row in the input file is a header record.
    • Treat records with fewer fields than defined as malformed – Toggle to YES to implement this global record handling option. You can learn more about handling malformed records here: Managing malformed input records
  5. Use the File Schema preview workspace to:
    1. Change the order of the input fields:
      1. Click any gray bar in front of a field name; the pointer changes to a hand.
      2. Hold down the mouse button and drag the field selection to its new position.
      3. Release the mouse button when the new position is correct.
      4. Click Regenerate to save the change.
    2. Rename a field – Double-click a field name to open a text input box, allowing you to change the name.
    3. Change the field content type – Double-click the Type column for any field to display the drop-down, and select a valid format for the field content.
    4. Selectively trim fields to their used length.
    5. Selectively define a field's locale or format – If available, double-click the Locale/Format column for any field, and change the definition.
    6. Selectively delete fields – Click the trash can: You will see a confirmation message before you can proceed.
    Tip: Use the Regenerate button to re-examine and re-display the file schema after you make changes.
  6. Click Apply so that your changes take effect, or click Cancel to return to the workflow canvas without saving changes.
You are ready to Configure the Sort tab details - Input stage.