Mapping two inputs to a single output

Configure your map to combine two parallel loops into nested loops.

1. Place the input row1Record element to the output customer element to automatically map the id, name and city elements.
2. Click the output bill element and place a SimpleLoop function in its Loop tab, then place the input row2Record element on the Input Map Element argument.
3. Place an Equal function on the Filter argument, then place the input customerId element on the First Value argument, and the output customer/id on Second Value.

   Example

   

4. Place the input billId on the output bill/id and the input price on the output price.
5. Save your map, then open the Job in the Integration perspective, go to the Run tab and run the Job.

<?xml version="1.0" encoding="UTF-8"?>
<root>
   <customer>
      <id>111</id>
      <name>John</name>
      <city>New York</city>
      <bill>
         <id>asd-589</id>
         <price>123.58</price>
      </bill>
   </customer>
   <customer>
      <id>591</id>
      <name>Billy</name>
      <city>Los Angeles</city>
      <bill>
         <id>sry-84u</id>
         <price>352.89</price>
      </bill>
      <bill>
         <id>xoi-htr</id>
         <price>36.55</price>
      </bill>
   </customer>
   <customer>
      <id>891</id>
      <name>Bob</name>
      <city>Chicago</city>
      <bill>
         <id>111-gfs</id>
         <price>3.58</price>
      </bill>
      <bill>
         <id>8j9-t44</id>
         <price>99.95</price>
      </bill>
      <bill>
         <id>999-gre</id>
         <price>799.95</price>
      </bill>
   </customer>
</root>