Configuring the second subjob: reading and writing positional data

Positional

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Data Integration
Talend Open Studio for Big Data
Talend ESB
Talend MDM Platform
Talend Data Management Platform
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Talend Big Data Platform
Talend Data Services Platform
Talend Big Data
Talend Data Fabric
task
Data Quality and Preparation > Third-party systems > File components (Integration) > Positional components
Design and Development > Third-party systems > File components (Integration) > Positional components
Data Governance > Third-party systems > File components (Integration) > Positional components
EnrichPlatform
Talend Studio

Procedure

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

    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.