Creating Temporary Variables

Temporary variables can be used to store values that you want to use in a field mapping expression.  These are typically used when a field mapping assignment cannot be performed in a single step. 

To create a temporary variable, click on the variables button at the bottom on the field mapping list.

The following pop-up screen is then displayed allowing you to create one or more variables of type boolean, currency, date, decimal, integer, timestamp, time or string:

Once temporary variables have been defined they will appear in green at the top of the field mapping list like this:

To set the value of a temporary variable, use any of these field mapping types described above, (Simple, Assignment, Lookup, Value Match, Reference or ID List).  Once the variable mapping has been defined, it will appear in the field mapping list like this:

Using temporary variables in expressions

Once a temporary variable has been defined and mapped, it can then be used in expressions to set a target field value or another temporary variable.  For example it could be used to set the value of a field on the target table using an assignment mapping expression like this:

SUBSTRING(#!Change Manager Email!#,0,STRPOS(#!Change Manager Email!#,'@'))

Note that the temporary variable is automatically enclosed with #! and !# delimiters.

Temporary variables can also be used in lookup queries like this:

The lookup query can then be used to set another field on the target table.

For more information on Lookup Queries, see the articles in this section: Defining Lookup Queries