Executing a sub-transformation

There are two dedicated steps to use or execute a sub-transformation: Mapping (sub-transformation) step and Simple Mapping (sub-transformation) step. To execute a sub-transformation like the one created earlier, we will use the second one.

In this example, we will read a file that looks like the following one:

student_code;name;writing;reading;speaking;listening80711-85;William Miller;81;83;80;9020362-34;Jennifer Martin;87;76;70;8075283-17;Margaret Wilson;99;94;90;8083714-28;Helen Thomas;89;97;80;8061666-55;Maria Thomas;88;77;70;80...

After reading the file, we will call the sub-transformation to split the student's name.

Before starting, get the sample files from the book site. You will find several files, ...

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.