Skip to main content Skip to complementary content
Announcements

Configuring the second subJob: reading and writing positional data

Procedure

  1. Double-click the tFileInputPositional component to open its Basic settings view.
    Information noteWarning:

    The dynamic schema feature is only supported in Built-In mode and requires the input file to have a header row.

  2. Select the Use existing dynamic check box, and in from the Component List that appears, select the tSetDynamicSchema component you use to create the dynamic schema. In this use case, only one tSetDynamicSchema component is used, so it is automatically selected.
  3. In the File name/Stream field, enter the path to the input positional file, or browse to the file path by clicking the [...] button.
  4. Fill in the Header, Footer and Limit fields according to your input file structure and your need. In this scenario, we only need to skip the first row when reading the input file. To do this, fill the Header field with 1 and leave the other fields as they are.
  5. Click the [...] button next to Edit schema to open the Schema dialog box, define only one column, dyn in this example, and select Dynamic from the Type list. Then, click OK to close the Schema dialog box and propagate the changes.
  6. Select the Customize check box, enter '-' in the Padding char field, and keep the other settings as they are.
  7. Double-click the tFileOutputPositional component to open its Basic settings view.
  8. Select the Use existing dynamic check box, specify the output file path, and select the Include header check box.
  9. In the Padding char field, enter ' ' so that the padding characters will be replaced with space in the output file.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here