O'Reilly logo

Pentaho 3.2 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—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 is ...

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