Configuring the components - Cloud - 8.0


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
Talend Studio
ジョブデザインと開発 > サードパーティーシステム > データクオリティコンポーネント > 標準化
データガバナンス > サードパーティーシステム > データクオリティコンポーネント > 標準化
データクオリティとプレパレーション > サードパーティーシステム > データクオリティコンポーネント > 標準化
Last publication date


  1. Double-click the first tFileInputDelimited component to open its Basic settings view.
  2. Set the parameters of the main input flow, including the path and name of the file to read and the number of header rows to skip.
    In this example, the main input file provides a list of people names and US state names. The following shows an extract of the file content:
    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. Click the [...] button next to Edit schema to open the Schema dialog box and set the input schema.
    According to the structure of the main input file, the input schema should contain two columns: name and state.
    When done, click OK to close the dialog box and propagate the changes to the next component.
  4. Define the properties of the second tFileInputDelimited component similarly.
    In this example, the reference input file provides a list of states and their two-letter codes. Accordingly, the reference input schema should have two columns: State and Code.
  5. Double-click the tReplaceList component to open its Basic settings view to set the operation to carry out.
  6. From the Lookup search column list, select the column to be searched.
    In this example, select the State column.
  7. From the Lookup replacement column list, select the column containing the replacement values.
    In this example, select the Code column.
  8. In the Column options table, select Replace check box for the State column, to replace the state names with their corresponding codes.
  9. In the tLogRow component, select the Table check box for a better readability of the output.