You can include a specific number of multiple-occurring elements in an output group.
To pivot multiple-occurring elements, map the multiple-occurring child element to the parent group of output ports. The Developer tool prompts you to define the number of child elements to include in the parent.
Pivoted Relational Output Example
You want to transform an XML hierarchy that contains employee details with multiple IDs to a relational output group with separate output elements for the employee IDs.
The following example shows two instances of Employee_ID in the Departments relational output group: