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:
- Create a new Transformation.
- Add a Data Grid and a JavaScript step to the work area. Create a hop from the grid toward the other step.
- Use the Data Grid step to define a field named word ...