A one-sided mapping stores literal data into a target message (see Types of mappings).
The following transforms do one-sided mapping:
| Transform: | Description: |
|---|---|
| Assign | Assigns a literal value to a target message. The literal value and the target element must have the same type.1 |
| Clear | Sets the target element to spaces. The target element must be a string. |
| Current Date, Current Time, Current Timestamp | Sets the target element to the current date, the current time, or the current date and time. The target element must be a string. |
| Custom Mapping | Provides the user with the ability to specify complex mapping statements expressed in ESQL. |
| 1 Specifying text for an Assign transform: The Value field on the General tab of the Assign transform expects normal text not an ESQL expression. Therefore do not surround text in this field with single quotes unless you want the single quotes to be part of the string (see Assign transform). For example, to use the Assign transform to store the string JOE into a variable enter JOE not 'JOE'. | |
A one-to-one mapping reads data from a single source element and stores a result into a single target element (see Types of mappings).
The following transforms do one-to-one mappings:
| Transform: | Description: |
|---|---|
| ACOS, ASIN, ATAN, COS, SIN, TAN | Returns the value of a trigonometric function. Both the source element and the target element must be numeric. |
| Cast | Casts the source element to the type of the target element. |
| Custom Mapping | Provides the user with the ability to specify complex mapping statements expressed in ESQL. |
| Length | Returns the length of the source element. The source element must be a string and the target element must be numeric. |
| LOG, LOG10 | Returns the natural logarithm or the 10-based logarithim of the source element. Both the source element and the target element must be numeric. |
| Lower Case | Returns the value of the source element in lower case. Both the source and target elements must be strings. |
| Move | Moves the value of the source element to the target element. Both the source and target elements must have the same type |
| Overlay | Returns a string overlaid with another string at a location indicated by offset and length parameters. Both the source and target elements must be strings. |
| Substring | Substring – Returns the portion of the source element indicated by offset and length parameters. Both the source and target elements must be strings. |
| Upper Case | Returns the value of the source element in upper case. Both the source and target elements must be strings. |
A many-to-one mapping reads data from multiple source elements and stores a result into a single target element (see Types of mappings).
The following transforms do many-to-one mappings:
| Transform: | Description: |
|---|---|
| Add | Adds the second source element to the first source element. The two source elements and the target element must be strings. |
| Concatenate | Concatenates the second source element to the first source element. The two source elements and the target element must be numeric. |
| Custom Mapping | Provides the user with the ability to specify complex mapping statements expressed in ESQL. |
| Divide | Divides the first source element by the second source element. The two source elements and the target element must be numeric. |
| Multiply | Multiplies the first source element by the second source element. The two source elements and the target element must be numeric. |
| Subtract | Divides the second source element by the first source element. The two source elements and the target element must be numeric. |
A group mapping is a mapping in which the source element and the target element are groups (see Types of mappings).
The following transforms do group mappings:
| Transform: | Description: |
|---|---|
| Custom Mapping | Provides the user with the ability to specify complex mapping statements expressed in ESQL. |
| Move | Moves the value of the source group to the target group. Both the source and target groups must have the same structure. |