Configuring the first subJob: creating a dynamic schema - Cloud - 8.0

Positional

Version
Cloud
8.0
Language
English
Product
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
Module
Talend Studio
Content
Data Governance > Third-party systems > File components (Integration) > Positional components
Data Quality and Preparation > Third-party systems > File components (Integration) > Positional components
Design and Development > Third-party systems > File components (Integration) > Positional components
Last publication date
2024-02-20

Procedure

  1. Double-click the tFixedFlowInput component to show its Basic settings view and define its properties.
  2. Click the [...] button next to Edit schema to open the Schema dialog box.
  3. Click the [+] button to add three columns: ColumnName, ColumnType, and ColumnLength, and set their types to String, String, and Integer respectively to define the minimum properties required for a positional file schema. Then, click OK to close the dialog box.
  4. Select the Use Inline Table option, click the [+] button three times to add three lines, give them a name in the ColumnName field, according to the actual columns of the input file to read: ID, Name, and City, set their types in the corresponding ColumnType field: id_Interger for column ID, and id_String for columns Name and City, and set the length values of the columns in the corresponding ColumnLength field. Note that the column names you give in this table will compose the header of the output file.
  5. Double-click the tSetDynamicSchema component to open its Basic settings view.
  6. Click Sync columns to ensure that the schema structure is properly retrieved from the preceding component.
  7. Under the Parameters table, click the [+] button to add three lines in the table.
  8. Click in the Property field for each line, and select ColumnName, Type, and Length respectively.
  9. Click in the Value field for each line, and select ColumnName, ColumnType, and ColumnLength respectively.
    Now, with the values set in the inline table of the tFixedFlowInput component retrieved, the following data structure is defined in the dynamic schema:
    Column Name Type Length
    ID Integer 6
    Name String 12
    City String 12