Performing other useful operations on dates

Despite the full list of options, there is a possibility that a function you are looking for is not available in any PDI step. Suppose that, among the descriptive fields for a date, you want the name of the month in your local language or the current date in a different time zone. None of the presented steps provides that information.

Fortunately, there is always the code resource. Under the Scripting category of steps, there are several steps that can be used for this purpose: Modified Java Script ValueUser Defined Java Class, and User Defined Java Expression. These steps allow you to use either Java or JavaScript libraries. The next subsection gives a brief introduction to the User Defined Java ...

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.