Pentaho Data Integration Beginner's Guide

Chapter 4. Filtering, Searching, and Performing Other Useful Operations with Data

In the previous chapters, you learned the basics of transforming data. The kind of operations that you learned are useful but limited. This chapter expands your knowledge by teaching you a variety of essential features, such as sorting or filtering data, among others.

In this chapter, you will learn about:

• Filtering and sorting data
• Grouping data by different criteria
• Looking up for data outside the main stream of data
• Data cleaning

Sorting data

Until now, you worked with data, transforming it in several ways, but you were never worried about the order in which the data came. Do you remember the file about matching games that you read in the previous chapter? It would ...