Until now you learned how to accomplish several kinds of calculations that enriched the set of data. There is still another kind of operation that is frequently used, and does not have to do with enriching the data but with discarding data. It is filtering unwanted data. Now you will learn how to discard rows under given conditions.

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.