Specifying ForEach Mapping Properties
Following are the properties of ForEach mapping:
Filter Input: Specifies the matching condition for filtering the input array elements. At run time,
Integration Server evaluates the condition for each input array element and if the condition evaluates to true, the mappings defined in the
ForEach mapping pipeline are executed.
Copy Mode: Specifies how to copy the elements from input to output array. Following copy modes are supported:
Append: Appends the output array.
Merge: Updates the existing output array with source values. This is the default mode.
Overwrite: Overwrites the output array.
Elements Selection: Specifies the indexes of the input array that participate in the
ForEach mapping. The first index element is 0. You can specify multiple cardinalities using the " , " delimiter. Consider the following example:
If you specify an index value... | Then ForEach processes... |
3 | only the fourth element of the input array. |
1,5 | only the second and the sixth elements of the input array. |
1-6,9,10 | all second to seventh, tenth, and eleventh elements of the input array. |
Empty | all the elements of the input array. |
Note:
You should specify the indexes in the increasing order.
Note:
When you specify both Elements Selection and Filter Input, then ForEach first selects elements based on the Elements Selection and then applies the Filter Input conditions on selected elements.
To specify ForEach mapping properties
2. On the ForEach mapping, click . The ForEach Settings dialog box appears.
3. On the Filter Input screen, enter the filter condition for the ForEach mapping and click Next.
4. In the Copy Mode screen, select the required copy action and click Next.
5. In the Elements Selection screen, enter the indexes of the input array.
6. Click Finish.
A ForEach mapping is established between the selected variables.