Imagine you are responsible to collect the results of an annual examination that is being taken in a language school. The examination evaluates writing, reading, speaking, and listening skills. Every professor gives the exam to the students, the students take the examination, the professors grade the examinations in the scale 0-100 for each skill, and write the results in a text file, like the following:
student_code;name;writing;reading;speaking;listening 80711-85;William Miller;81;83;80;90 20362-34;Jennifer Martin;87;76;70;80 75283-17;Margaret Wilson;99;94;90;80 83714-28;Helen Thomas;89;97;80;80 61666-55;Maria Thomas;88;77;70;80
All the files follow that pattern.
When a professor has the file ready, he/she sends it to you, and you have to integrate the results in a global list. Let's do it with Kettle.
Before starting, be sure to have a file ready to read. Type it or download the sample files from the Packt's official website.
Create...