Recently encountered a problem when using kettle, you need to format the input field, the logic is complex (need to replace the specified string, and then the number of parts less than four bits of the number before 0), the kettle does not provide a direct plug-in to support complex business logic processing, So write your own code to handle it.
Java code and JavaScript code can be supported in kettle, Java code I tried several times, not too stable, so I used JavaScript
1. Select the JavaScript code in the script on the left
2. The fields passed in the previous step are in input field and can be referenced directly in JavaScript code.
3. Using JavaScript to implement business logic, the computed result fields obtained after business processing can add new fields by defining new variables in JavaScript code
Such as:
An example of using JavaScript in kettle