Overview
The Assign transform sets a value that can be a fixed value or it can be the result of a function that has no input; for example, a current date function.
You cannot use the value of an input element to set the value of an output element with the Assign transform.
The output element is set to a constant value.
The output element must be a simple type element.
For more information about assigning a value to an output element, see Setting the value of an output element to a simple data type.
Assign a value
You must assign a value in the Value field located in the General tab of the Assign transform properties view.
If you do not specify a value, an empty element is created.
Define a conditional expression
You can define supplement connections between input elements and the Assign transform. You can then use these input elements in a conditional expression that defines the condition under which the transform should be applied. If the condition evaluates to true, the transform is applied.
- Sort: You can sort the inputs to the transform by ascending order, descending order, case order, or data order.
- Order: You can display the order of input connections to a transform. You can reorder them.
For more information on how to configure these properties, see Configuring a mapping transform properties.
Default values
| Type | Default value |
|---|---|
| string | Empty string |
| dateTime | 2002-01-01T11:00:00 |
| boolean | false |
| decimal | 0.0 |
| double | 0.0 |
| hexBinary | 00 |
| long | 0 |
| duration | P1Y |
| time | 00:00:00 |
| date | 2002-01-01 |
Last updated Friday, 21 July 2017