Creating and testing a sub-transformation

To explain how to develop a sub-transformation, we will create a very simple one. Our sub-transformation will have the purpose of taking a text as the input and splitting it into two fields in the following way: if the text is Pentaho Data Integration, the sub-transformation will split it into two—the first field will be Pentaho and the second field will be DATA INTEGRATION. Very simple but enough for demonstrating purposes.

First of all, we will create a regular Transformation that implements this functionality:

  1. Create a new Transformation.
  2. Add a Data Grid and a JavaScript step to the work area. Create a hop from the grid toward the other step.
  3. Use the  Data Grid step to define a field named word ...

Get Learning Pentaho Data Integration 8 CE - Third Edition 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.