The Expression builder is a feature of the Data mapping processor that allows you to write expressions in a code editor to perform various operations on your data while mapping fields together.
The language used in this code editor is the Data Shaping Expression Language. For more details on how to use it and examples, read the corresponding documentation.
In this example, the input fields FIRSTNAME and LASTNAME are mapped with the output field CUSTOMER_NAME, and the following expression is used to concatenate them and add a space between the first name and the last name:
concat(FIRSTNAME,' ', LASTNAME)- click the
icon that appears when hovering the Input
selection fields. The code editor opens and lets you enter the
expression using the Data Shaping Expression Language.
Built-in help: To get started with expressions, you can click the
button at the
bottom of the code editor. Note that code validation is being run while you enter
your expression to make sure it is valid. - click the
icon at the bottom of the code editor to validate your expression and close the
code editor.
- select the mapping you want to delete, and click the
icon on the top toolbar of the Data mapping page. A warning message informs
you that both the mapping and the expression linked to it will be deleted if you
confirm this action.