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

Business rules

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
Talend Studio
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


  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.