Configuring the components - 7.3

Processing (Integration)
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Processing components (Integration)
Data Quality and Preparation > Third-party systems > Processing components (Integration)
Design and Development > Third-party systems > Processing components (Integration)

Procedure

  1. Double-click the tFileInputDelimited component to open its Basic settings view in the Component tab.
  2. Click the [...] button next to the File name/Stream field to browse to the file from which you want to read the input flow. In this example, the input file is Names&States.csv, which contains two columns: name and state. 
    name;state
Andrew Kennedy;Mississippi
Benjamin Carter;Louisiana
Benjamin Monroe;West Virginia
Bill Harrison;Tennessee
Calvin Grant;Virginia
Chester Harrison;Rhode Island
Chester Hoover;Kansas
Chester Kennedy;Maryland
Chester Polk;Indiana
Dwight Nixon;Nevada
Dwight Roosevelt;Mississippi
Franklin Grant;Nebraska
  3. Fill in the Header, Footer and Limit fields according to your needs. In this example, type in 1 in the Header field to skip the first row of the input file.
  4. Click Edit schema to define the data structure of the input flow.
  5. Double-click the first tSortRow component to open its Basic settings view.
  6. In the Criteria panel, click the [+] button to add one row and set the sorting parameters for the schema column to be processed. To sort the input data by name, select name under Schema column. Select alpha as the sorting type and asc as the sorting order.
    For more information about those parameters, see tSortRow Standard properties.
  7. Double-click the second tSortRow component and repeat the step above to define the sorting parameters for the state column.
  8. In the Basic settings view of each tLogRow component, select Table in the Mode area for a better view of the Job execution result.