Chapter 14. Opening the Output File

Now expand the data-out folder in the Navigator pane.

Figure 14.1. Expanding the Data-Out Folder in the Navigator Pane

Select the output.out file, right-click it and select Open With → Text Editor.

Figure 14.2. Opening the Output File

You will see the following window:

Figure 14.3. Output Data Records

This data are the output data records. You can see that all salaries are greater than 24000 and they are sorted in descending order. Note that (within the same salary of 30000) both Browns lies above George Smith and that Albert Brown lies higher than Peter Brown.

Note that neither George Hardy, nor Richard Gordon, nor Michael Lester are included in the output data file. The reason is that their salaries are not greater than 24000.

Thus, we have shown you how you can create a graph that can sort data in ascending and/or descending order according to specified key, filter sorted incoming records and reject data records with salaries equal or lower than 24000. All your graphs can be built in a similar way.

(You could have more records in the input file. Your data files could have the names like the following ones: employees.dat instead of input.dat, and topemployees.out instead of output.out. It depends on you. However, we wanted to present only a brief introductory overview of how you can create CloverETL graphs.)