Scenario: Delimited file content display - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The following scenario creates a two-component Job, which aims at reading each row of a file, selecting delimited data and displaying the output in the Run log console.

Dropping and linking components

  1. Drop a tFileInputDelimited component and a tLogRow component from the Palette to the design workspace.

  2. Right-click on the tFileInputDelimited component and select Row > Main. Then drag it onto the tLogRow component and release when the plug symbol shows up.

Configuring the components

  1. Select the tFileInputDelimited component again, and define its Basic settings:

  2. Fill in a path to the file in the File Name field. This field is mandatory.

    Warning

    If the path of the file contains some accented characters, you will get an error message when executing your Job. For more information regarding the procedures to follow when the support of accented characters is missing, see the Talend Installation Guide.

  3. Define the Row separator allowing to identify the end of a row. Then define the Field separator used to delimit fields in a row.

  4. In this scenario, the header and footer limits are not set. And the Limit number of processed rows is set on 50.

  5. Set the Schema as either a local (Built-in) or a remotely managed (Repository) to define the data to pass on to the tLogRow component.

  6. You can load and/or edit the schema via the Edit Schema function.

    Related topics: see Talend Studio User Guide.

  7. Enter the encoding standard the input file is encoded in. This setting is meant to ensure encoding consistency throughout all input and output files.

  8. Select the tLogRow and define the Field separator to use for the output display. Related topic: tLogRow.

  9. Select the Print schema column name in front of each value check box to retrieve the column labels in the output displayed.

Saving and executing the Job

  1. Press Ctrl+S to save your Job.

  2. Go to Run tab, and click on Run to execute the Job.

    The file is read row by row and the extracted fields are displayed on the Run log as defined in both components Basic settings.

    The Log sums up all parameters in a header followed by the result of the Job.