Скачать или смотреть How to Remove Duplicate Parent Nodes and Sum Their Values Using XSLT

Learn how to efficiently remove duplicate parent nodes in XML based on their child elements and sum specific values using XSLT.
---
This video is based on the question https://stackoverflow.com/q/70158408/ asked by the user 'keeskroket' ( https://stackoverflow.com/u/16873581/ ) and on the answer https://stackoverflow.com/a/70158631/ provided by the user 'Martin Honnen' ( https://stackoverflow.com/u/252228/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Remove duplicate parent node based on child node and add specific element values in the concerning node

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Introduction

XML is widely used for data representation, but working with it can be challenging when duplicates occur. A common scenario involves needing to remove duplicate parent nodes and sum their respective child node values. In this guide, we will explore how to address this issue using XSLT (XML Stylesheet Language Transformations).

The Problem

Imagine you have the following XML structure:

[[See Video to Reveal this Text or Code Snippet]]

In this example, the Total elements with the same Category/ID of S contain duplicate information. The goal is to remove the duplicates and sum their TotalAmount and Tax values under a single parent node.

The Solution

To solve this task using XSLT, follow these steps outlined below.

Step 1: Setting Up the Key

First, create a key for grouping the Total elements based on the Category/ID. This allows us to identify duplicates efficiently.

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Identity Transformation

Next, implement the identity transformation template, which is a standard practice to copy all nodes as they are, unless modified.

[[See Video to Reveal this Text or Code Snippet]]

Step 3: Filtering out Duplicates

To filter duplicates, you need a template that matches Total elements, but only if they are not the first occurrence of their kind.

[[See Video to Reveal this Text or Code Snippet]]

Step 4: Summing Values

Now, create templates to sum up the TotalAmount and Tax values for the duplicates. This involves copying the relevant attributes and summing the values of the Total elements grouped by Category/ID.

[[See Video to Reveal this Text or Code Snippet]]

Full XSLT Code

Putting all pieces together, we get the following complete XSLT style sheet:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

By utilizing this structured XSLT stylesheet, you can effectively remove duplicate parent nodes from your XML data based on child elements. Not only does this approach enhance data clarity, but it also helps in maintaining data integrity while simplifying XML structures. This technique is particularly useful for data analysis, reporting, or aggregating totals in various applications.

Now you can implement your XSLT transformation with ease and enjoy a cleaner, more focused XML output!