Doing some math with Numeric fields

Some of the steps presented for string operations are also suited for some math. Calculator is the first step you should look for if you intend to do simple operations, for example, addition, subtraction, division, percentage, among others.

For math operations, there is also the Formula step. The advantage of Formula compared to Calculator is that you can state more elaborated expressions that contain logical, mathematical, and relational operators. Among the available functions, there are some statistical options such as MAX, MIN, and Average.

As an example of how to use a Formula step, suppose that you have three Integer fields named a, b, and c and you want to create a new field as follows: If all the ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.