Configuring data input - 7.3

Positional

Version
7.3
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-21

Procedure

  1. Double-click the tFileInputPositional component to show its Basic settings view and define its properties.
  2. Define the Job Property type if needed. For this scenario, we use the built-in Property type.
    As opposed to the Repository, this means that the Property type is set for this station only.
  3. Fill in a path to the input file in the File Name field. This field is mandatory.
  4. Define the Row separator identifying the end of a row if needed, by default, a carriage return.
  5. If required, select the Use byte length as the cardinality check box to enable the support of double-byte character.
  6. Define the Pattern to delimit fields in a row. The pattern is a series of length values corresponding to the values of your input files. The values should be entered between quotes, and separated by a comma. Make sure the values you enter match the schema defined.
  7. 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.
  8. Next to Schema, select Repository if the input schema is stored in the Repository. In this use case, we use a Built-In input schema to define the data to pass on to the tFileOutputXML component.
  9. You can load and/or edit the schema via the Edit Schema function. For this schema, define three columns, respectively Contract, CustomerRef and InsuranceNr matching the structure of the input file. Then, click OK to close the Schema dialog box and propagate the changes.