Configuring the input component

Procedure

Double-click tFileInputExcel to open its Basic settings view and define the component properties:
In the Property type list, select Built-in and fill in the fields that follow.
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 brmsInput and it holds candidate data.

Information noteRestriction: The tBRMS component supports the XLSX format from version 8.0 R2022-09. If you are using a previous version, do not select Read excel2007 file format(xlsx).
If needed, right-click tFileInputExcel and select Data viewer to have a preview of the input data.
Select the All sheets check box to retrieve the data from all sheets of the excel file.
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.
Click OK to validate your changes and close the dialog box.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!