Configuring the second subjob: reading and writing positional data - 6.4

Dynamic Schema

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Custom code components (Integration) > Dynamic Schema components
Data Quality and Preparation > Third-party systems > Custom code components (Integration) > Dynamic Schema components
Design and Development > Third-party systems > Custom code components (Integration) > Dynamic Schema 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.