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 ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.