Pentaho 3.2 Data Integration Beginner's Guide

Time for action – reviewing examinations by using the Formula step

In this tutorial you will redo the previous exercise, but this time you will do the calculations with the Formula step.

1. Open the transformation you just finished.
2. Delete from the transformation the Calculator step, and put in its place a Formula step. You will find it under the Scripting category of steps.
3. Add a field named writing.
4. When you click the cell under the Formula column, a window appears to edit the formula for the new field.
5. In the upper area of the window, type [writing]/20. You will notice that the sentence is red if it is incomplete or the syntax is incorrect. In that case, the error is shown below the editing area, like in the following example:
6. As soon as the formula ...