Expression activity

Expression activity permits you to perform operations on data.

These can be single arithmetic operations, such as add, multiply, subtract, or string manipulation such as Trim, Uppercase, and Date functions such as add months, or get today's date.

For example, you can create an expression to display the initials of a name. If the name of a customer is Abc Xyz, and you need to display the initials AX, the rule can be: Left(FirstName,1) + Left(Surname,1)

The value from this rule is held in an output (target) variable.

An expression node reduces the amount of custom .NET code or scripting needed by providing the most used functions used for data manipulation. You can validate and test the expression.

You can set the value of one or more variables using free text, variables, operators, and functions.

See the following table for the variables supported and not supported by an Expression node.

Supported Not supported
Bool (Boolean) Checklist
Byte Complex
Currency Dynamic complex
Date XML
Decimal XML expression
Double System variables
Float
Long
Nullable date
Nullable string
Short
String
Entity attributes (simple types)

How to: Configure an Expression activity