In the previous example, we demonstrated how to manipulate the schemas and basic mapping of input columns to output columns. This recipe will show how to add much more complex rules to tMap
and how to use the Talend supplied functions.
Expressions are limited to a single line of Java code, but can contain any of the following:
Constants
Input variables
The
globalMap
andcontext
variablesThe
tMap
variables (see next recipe)Talend supplied functions
User supplied code routines
Standard Custom java functions
Included methods from JAR files
Open
tMap
.Click the left mouse button on the output
transactionDateTime
column.You will notice that the expression button looks like the following:
Click on the … button to open the Expression Builder dialogue.
Adding a Talend function
The bottom-left panel lists the Categories of Talend functions. Scroll down to the TalendDate category and click the left mouse button...