XML Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Generating Rows in Circular Relationships

By default, the Integration Service generates rows for all occurrences of data in a circular relationship. You can choose to create a row for only the first occurrence. Select the Non-Recursive row option.

The following XML file contains a Part element with a circular reference:

<?xml version="1.0" encoding="utf-8"?>
<Vehicle xmlns="http://www.PartInvoice.org"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.PartInvoice.org part.xsd">
<VehInfo>
  	<make>Honda</make>
  	<model>Civic</model>
  	<type>Compact</type>
</VehInfo>
<Part>
  <ID>123</ID>
  <Name>Body</Name>
  <Type>Exterior</Type>
  <Part>
    <ID>111</ID>
    <Name>DoorFL</Name>
	    <Type>Exterior</Type>
	    <Part>
      <ID>1112</ID>
      <Name>KnobL</Name>
      <Type>Exterior</Type>
    </Part>	     
    <Part>
      <ID>1113</ID>
      <Name>Window</Name>
      <Type>Exterior</Type>
    </Part>
  </Part>
</Part>
</Vehicle>

The following figure shows that the Part element is the view row for the X_par_Part view in the XML definition:

The Part element is the view row for the X_par_Part view in the XML definition. The Part element includes associated ID, Name and Type strings.

The following figure shows that the Integration Services generates rows for Part 123 and all of the component parts when you run a session:

The data contains four rows and the columns, par_ID, par_Name, and par_Type. The first value in the par_ID column is 123, followed by the component part values. The NonRecursive Row box above the data is not selected.

The following figure shows that the Integration Service reads the first occurrence of the Part element and generates one row of data for Part 123 when you select NonRecursive Row:

The data contains one row and the columns, par_ID, par_Name and par_Type. The value in the par_ID column is 123. The NonRecursive Row option is selected.

Rename Saved Search

Table of Contents

XML Guide

XML Guide

Generating Rows in Circular Relationships

Generating Rows in Circular Relationships