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.

Note:
For information about the syntax used in conditions, see Conditional Expressions.

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

1. Create a ForEach mapping between the array variables. See Creating a ForEach Mapping.

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.