Whatever Transformation you need to do on your data, you have a good chance of finding Pentaho Data Integration (PDI) steps able to do the Job. Despite that, it may be that there are no proper steps that serve your requirements or that an apparently minor Transformation consumes a lot of steps linked in a very confusing arrangement that is difficult to test or understand. Dropping colorful icons here and there and making notes to clarify a Transformation can be practical to a point, but there are some situations like the ones described here where you inevitably will have to code.
This chapter explains how to insert code into your transformations. Specifically, you will learn the following topics:
- Doing simple tasks with the JavaScript step
- Parsing unstructured files with JavaScript
- Doing simple tasks with the JavaScript step
- Avoiding coding using...