This chapter covered the simplest and most common ways of transforming data. Specifically, it covered how to:

  • Use different transformation steps to calculate new fields
  • Use the Calculator and the Formula steps
  • Filter and sort data
  • Calculate statistics on groups of rows
  • Look up data

After learning basic manipulation of data, you may now create more complex transformations, where the streams begin to split and merge. That is the core subject of the next chapter.

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.