Step 2: Configuring the Unstructured Data stage
Configure the Unstructured Data stage to extract data from multiple Microsoft Excel sheets.
Procedure
- Double-click the Unstructured Data stage to open the stage properties.
- Click Configure.
- In the Configuration window, specify the full file path of the Microsoft Excel input file Employee3.xls.
- Specify the data to extract from the Departments spreadsheet
and complete the below sub steps to generate the column mappings.
- From the Link list box, select Departments
- From the Range option list, select Specify the entire range
- From the Range expression field, specify Departments!A2:C6
- From the Column header, select First row of data ranges
- Click Load. The Excel columns in the specified data range are listed in the Import pane.
- Specify the data to extract from the Employees spreadsheet
and complete the below sub steps to generate the column mappings.
- From the Link list box, select Employees.
- From the Range Option list, Specify the entire range
- From the Range expression field, specify Employees!A2:L34
- From the Column header, select First row of data ranges.
- Click Load. The Excel columns in the specified data range are listed in the Import pane.
- Click Import, and then click OK. The stage maps columns.
- Confirm that the values that you entered on the Configuration window are saved on the Property tab of the stage editor.
- On the Output page, select the Employees link as the Output name.
- On the Columns page, change the data type of the EMP_NO column to integer, and then click OK.