Designing the Job and configuring the input data - Cloud - 8.0

Business rules
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 > Processing components (Integration) > Business rules components
Data Quality and Preparation > Third-party systems > Processing components (Integration) > Business rules components
Design and Development > Third-party systems > Processing components (Integration) > Business rules components

Procedure

  1. Drop the following components from the Palette to the design workspace: tFileInputExcel, tRules and two tLogRow.
  2. Double-click tFileInputExcel to display its Basic settings view and define the component properties.
  3. In the Property type list, select Built-in and fill in the fields that follow.
  4. Click the [...] button next to the File Name/Stream field and browse to the source file to set its path and name. The source file used in this example is called client and it holds client data.
    Note: As tRules does not support the .xlsx format, do not select Read excel2007 file format(xlsx).
  5. If needed, right-click tFileInputExcel and select Data viewer to have a preview of the input data.
  6. Select the All sheets check box to retrieve the data from all sheets of the excel file.
  7. From the Schema list, select Built-in and click Edit schema to open a dialog box where you can define the schema of the input file.

    In this example, the source file holds four columns: id, name, age and region.

  8. Click OK to validate your changes and close the dialog box.