XML Structure Tab: Eliminate Duplicates Column

Explanation | Examples

Applies to: Marshalling data to XML only

Available: For mapped nodes only. When you have placed a checkmark in the "Combined Node" column for an element, for each element that shows a combined status, either directly set or inherited.

Possible values:

Not currently set. You may check this node to eliminate duplicate occurrences of children of this node.

Duplicate occurrences of children of this node will be eliminated from the results of the marshal operation.

Explanation

Summary | Examples

When Eliminate Duplicates is set on a node, the engine examines the entire child structure of the node on which it is set.  It compares the tag, node name, attributes, sub-nodes and the whole subtree. As soon as a mismatch is found, the node is discarded. If no mismatch is found, a duplicate node is removed from the XML output.

Examples

Summary | Explanation

 

 

Marshal with Combine Project

Overview of the project used in examples below.

1.

Marshal Without Combine

No settings have been made in the XML Structure tab

2.

Marshal with Combine

XML output combines all PurchaseOrder nodes that have a matching value for the OrderID node.

3.

Marshal with Combine and Group

 XML output groups  all matching elements (LineItem) together

4.

 

Marshal with Combine and Order By

XML output contains records retrieved from the database using an ORDER BY clause

5.

Marshal with Optimized Combine

XML output generated using the Optimized Combine feature in the XML Structure tab.

See Also

XML Structure Tab
Introduction to Combining Nodes in XML Output When Marshalling

Combining Duplicate Elements in XML Output

Customizing Combine Settings for XML Output