Pentaho 3.2 Data Integration Beginner's Guide

Summary

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.