O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – refining the counting task by filtering even more

This is the second tutorial on filtering. As discussed in the previous tutorial, we have a plain file and want to know what kind of information is present in it. In the previous section, we listed and counted the words in the file. Now, we will apply some extra filters in order to refine our work.

  1. Open the transformation from the previous section.
  2. Add a Calculator step, link it to the last step, and calculate the new field len_word representing the length of the words. To do this use the calculator function Return the length of a string A. As Field A type or select word, and as Type select Integer.
  3. Expand the Flow category and drag another Filter rows step to the canvas.
  4. Link it to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required