When you map target object columns during the creation or editing a task, you can map a target column to an expression.
First click the Column list and select Expression. Then enter the expression in the box.
Expression can include the following:
- Source columns
- Numeric or string constants
- Arithmetic and logical operators ( AND OR NOT < > == + - * / ?: )
- Mathematical, string, and date&time functions
- NULL check and replace functions
- NULL value