Configuring the input component - 7.3

Business rules

author
Talend Documentation Team
EnrichVersion
Cloud
7.3
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 Real-Time Big Data Platform
task
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
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tFileInputExcel to open its Basic settings view and define the component properties:
  2. In the Property type list, select Built-in and fill in the fields that follow.
  3. Click the three-dot 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 brmsInput and it holds candidate data.
    Note: As tBRMS does not support the .xlsx format, do not select Read excel2007 file format(xlsx).
  4. If needed, right-click tFileInputExcel and select Data viewer to have a preview of the input data.
  5. Select the All sheets check box to retrieve the data from all sheets of the excel file.
  6. From the Schema list, select Built-in and click Edit schema to define the structure of the source data. In this example, five columns are defined for the input information of candidates.
  7. Click OK to validate your changes and close the dialog box.