Developer Transformation Guide

10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Pivoting Multiple-Occurring Ports

You can map multiple input ports to a multiple-occurring node in the SOAP message. The Developer tool pivots the input data into multiple nodes in the SOAP message.

To change the number of elements to pivot, choose

Override existing pivoting

in the

Map Options

dialog box.

If you remove one of the pivoted port instances from the

Ports

area, the Developer tool removes all instances from the

Operation

area.

Pivoting Example

An input group might have the following rows:

Num	Name	Location	emp_name1	emp_name2	emp_name3
101	HR	New York	Alice	Tom	Bob
102	Product	California	Carol	TIm	Dave

Each row contains a department number and three employees names.

Employee is a multiple-occurring node in the SOAP message hierarchy. You can map all instances of Employee from the input row to the SOAP message hierarchy. Select all occurrences of Employee. Click

Map

. The

Map Options

dialog box prompts you to choose a node from the list.

The Developer tool changes the Employee node to include the multiple name nodes in the SOAP message hierarchy:

Department
   num
   name
   location
   Employee     (unbounded)
       emp_name1
       emp_name2
       emp_name3

The SOAP message returns the following hierarchy:

<department>
   <num>101</num>
   <name>HR</name>
   <location>New York</location>
   <employee>
      <emp_name>Alice</name>
   </employee>
   <employee>
      <emp_name>Tom</name>
   </employee>
   <employee>
      <emp_name>Bob</name>
   </employee>       
</department>

<department>
   <num>102</num>
   <name>Product</name>
   <location>California</location>
   <employee>
      <emp_name>Carol</name>
   </employee>
   <employee>
      <emp_name>Tim</name>
   </employee>
   <employee>
      <emp_name>Dave</name>
   </employee>
  </department>

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

Pivoting Multiple-Occurring Ports

Pivoting Multiple-Occurring Ports

Pivoting Example