Configuring the input component - Cloud - 8.0

Delimited

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) > Delimited components
Data Quality and Preparation > Third-party systems > File components (Integration) > Delimited components
Design and Development > Third-party systems > File components (Integration) > Delimited components
Last publication date
2024-02-29

Procedure

  1. Double-click tFileInputDelimited to open its Basic settings view. All its property fields are automatically filled in because you defined your input file locally.
  2. If you do not define your input file locally in the Repository tree view, fill in the details manually after selecting Built-in in the Property type list.
  3. Click the [...] button next to the File Name field and browse to the input file, customer.csv in this example.
    Warning:

    If the path of the file contains some accented characters, you will get an error message when executing your Job.

  4. In the Row Separators and Field Separators fields, enter respectively "\n" and ";" as line and field separators.
  5. If needed, set the number of lines used as header and the number of lines used as footer in the corresponding fields and then set a limit for the number of processed rows.
    In this example, Header is set to 6 while Footer and Limit are not set.
  6. In the Schema field, schema is automatically set to Repository and your schema is already defined since you have stored your input file locally for this example. Otherwise, select Built-in and click the [...] button next to Edit Schema to open the Schema dialog box where you can define the input schema, and then click OK to close the dialog box.