The Expression Editor form allows you to easily edit and test DMT Expressions used by load jobs, in the load conditions and the load mapping value. It's accessible for any load job in the Load Mapping area by double clicking on the Value column or the Load Condition field.
Note: The expression editor can only be used to edit and test DMT Expressions. If you use the expression editor with database or ODBC specific expressions, its functionalities are disabled.
The expression area is where can enter and edit an expression.
Expression: This multiline text field is where you enter and edit the expression. When you open the expression editor, the underlying expression (i.e. the Value column or the Load condition from the Load Data Mapping) is automatically placed in this field.
Validate Syntax: Click this button to validate the syntax of the current expression. It signals any syntax errors with a message.
Evaluate Expr.: Click this button to evaluate the current expression. The expression result is displayed in a popup window.
For our example above, the expression result is a string containing "1234 - TEST".
This area contains 2 tabs displaying the lists of all the Data File Columns and Run Variables that can be used in the expression.
Each list contains 2 columns (same for both tabs):
In our example above, the data file columns ID and NAME contain the values "ID-1234" and "TEST".
This area displays a list of all the function and operator categories available to create DMT expressions.
When you click on a category, the functions or operators within this category are displayed on the "Function and Operators" area.
This area displays a list of all the function or operator from the selected category in the "Categories" area.
Tip: Double click on a function or operator name to automatically place it in the expression field.
This area displays a brief description of the function or operator currently selected in the "Functions and Operators" area.