Chapter 3. Basic Data Manipulation

In the previous chapter, you learned how to get data into PDI. Now you're ready to begin transforming that data. This chapter explains the simplest and most used ways of transforming data. We will cover the following:

  • Executing basic operations
  • Filtering and sorting of data
  • Looking up data outside the main stream of data

By the end of this chapter, you will be able to do simple but meaningful transformations on different types of data.

Basic calculations

You already know how to create a transformation and read data from an external source. Now, taking that data as a starting point, you will begin to do basic calculations.

Get Pentaho 3.2 Data Integration Beginner's Guide 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.