O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – calculating statistics with the use of a subtransformations

Suppose that you are responsible to collect the results of an annual examination that is being taken in a language school. The examination evaluates English, Mathematics, Science, History, and Geography skills. Every professor gives the exam paper to the students, the students take the examination, the professors grade the examinations on a scale of 0-100 for each skill, and write the results in a text file, like the following:

student_code;name;english;mathematics;science;history_and_geo 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 00647-35;David ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required