Expression Mapping

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 Mapping

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