Use the filesystem or folder popup menu to select Add -> DataSource.

The DataSource Wizard appears.

Select Text DataSource and click Next. In the screen that appears, enter a unique name for the data source, such as Employee.

Enter the URL (file path) in the text box or click the browse button to the right of the text box and select the EmpInfo.txt file from the Open dialog window.

Select the First line is header option.

Select the Qualifier as " and separator as Semicolon. Click Infer Schema to infer the columns. After setting the properties, the screen appears as shown in Figure 8.3, “Text DataSource Parameters”.Click Finish to add the text data source to the repository.

Figure 8.3. Text DataSource Parameters

Select the same location, and use the popup menu to select Add -> DataSource.

The DataSource Wizard appears. Select Properties DataSource and click Next.

Enter a unique name such as Prop_Emp.

Click Add Column to invoke the Add Column dialog window. Enter the column name as Dept_Name (same column name as in the text data source), Data type as String and the value as Computer. After entering the values, the Add Column dialog appears.

Click Ok to add the column to the Wizard. The screen appears as shown in Figure 8.4, “Properties DataSource”.

Figure 8.4. Properties DataSource

Click Finish to add the Prop_Emp data source to the repository.

Select Properties Samp, and use the popup menu to add a Composite DataSource called Comp1.

Double click the Comp1.ds data source to open the composite designer window.

Select and place the properties data source Prop_Emp on the diagram. Select the derivative processor from the Action bar of the designer window and place it on the diagram.

Connect the output of Prop_Emp to the input of the Derivative processor.

Open the Derivative Properties and select the Derived tab. Click Add Column.

In the Add Column dialog, enter the name as Department, data type as String and the value as dept. Click Ok to add the column to the wizard. After entering the properties, the processor window appears as shown in Figure 8.5, “Derivative Wizard”.

Figure 8.5. Derivative Wizard

Select the JavaScript tab and enter the following script in the window.

if (Dept_Name== "Computer") dept = "CPT";
else dept = "Others";

Click Finish.

Connect the output of the Derive-Dept processor to the Result. Select Result and choose View from the popup menu. The output will be displayed in the data window as shown in Figure 8.6, “Test Output”. Notice that the department Computer is mapped to CPT.

Figure 8.6. Test Output

Now delete the flow between the Prop_Emp data source and the Derive-Dept processor.

Select and place the Employee.ds data source in the designer window. Using the flow processor, connect the output of the Employee.ds data source to the input of the Derive-Dept processor. Select Result, and choose View from the popup menu. The output will be displayed in the data window as shown in Figure 8.7, “Full Output”. Notice that all the records containing the Computer department are mapped to "CPT", and the Other departments are mapped to others. The above procedure makes it easy to check the validity of the derived columns.

Figure 8.7. Full Output

Add a Properties DataSource named Prop_Emp1.

Add a column called Department with data type String and value Electronics.

Add a column called Salary with data type Integer and value 7500. The values are shown in Figure 8.8, “Prop_Emp1”.

Figure 8.8. Prop_Emp1

Click Finish to add the data source to the repository.

Add a Composite DataSource called Comp2.

Open the Composite diagram and and drag the Employee.ds file onto it. Add a Filter processor to the diagram as well.

Connect the output of the Employee DataSource to the input of the Filter processor.

Open the filter properties. In the row corresponding to the Dept_Name field, select the Equals option from the combo box of the When column. Enter the condition as ${Department}.

In the row corresponding to the Emp_Sal field, select the More Than option from the combo box of the When column. Enter the condition as ${Salary}. After entering the values, the page appears as shown in Figure 8.9, “Filter Wizard”. Click Finish.

Figure 8.9. Filter Wizard

Select the Parameters processor from the action bar and place it in the workspace of the designer window. Change the colour of the processor.

Connect the output of the Filter processor to the input of the Parameters processor

Select and place the Prop_Emp1 data source in the designer window workspace.

Connect the Prop_Emp1 DataSource with the params input of the Parameters processor. Also, connect the output of the Parameters processor to the Result.

Select Result, and choose View from the popup menu. The output is displayed as shown in Figure 8.10, “Output”.

Figure 8.10. Output

The values passed by the records of the Prop_Emp1 data source are matched with the dynamic parameters in the filter condition. Based on this, the records of the text data source satisfying the filter condition are fetched.