Скачать или смотреть How to Achieve Grouping and Select Distinct in XSLT 1.0

Learn how to solve the challenge of grouping and selecting distinct values in XSLT 1.0 with this comprehensive guide, including practical examples and a step-by-step approach.
---
This video is based on the question https://stackoverflow.com/q/67240541/ asked by the user 'Brij' ( https://stackoverflow.com/u/15475021/ ) and on the answer https://stackoverflow.com/a/67240856/ 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: Grouping and select distinct in XSLT 1.0

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.
---
Grouping and Select Distinct in XSLT 1.0

When dealing with XML data, one common task you may face is the need to group certain elements or select distinct values based on specific criteria. This is especially relevant for scenarios where you have multiple data entries and you want to consolidate that information for better clarity and analysis. If you're using XSLT 1.0, transforming your XML can be a bit challenging given its limitations compared to its successor, XSLT 2.0. In this guide, we'll tackle how to effectively achieve grouping and select distinct capabilities using XSLT 1.0.

The Problem

Consider the following XML structure that represents some test results:

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

Your goal is to extract unique test names and group test results by time. The output XML should look something like this:

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

However, achieving this grouping can be particularly challenging in XSLT 1.0.

The Solution

To work around the limitations of XSLT 1.0, you can use the Muenchian grouping technique, which involves creating keys for the elements you want to group. Here’s how to do it step-by-step.

Step 1: Define Keys

Define keys in your XSLT that will be used for grouping your data. You will need two keys: one for grouping by the name element and another for grouping by the col1 element (the time).

Step 2: Create Templates for Output

With the keys defined, you can now create templates that will match your XML structure and generate the desired output.

Example Code

Here’s a complete example of how this can be accomplished:

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

Explanation of the Code

Keys: The keys by-name and by-col1 are defined to group Row elements by their name and col1 values, respectively.

First Row Generation: We first create a Row for the test names using a for-each loop that selects the first occurrence of each unique name.

Second Row Generation: Next, we loop through the times (col1) to generate the second Row, where for each unique time, you can get the associated passCount and failCount by using the key we previously defined.

Conclusion

By applying the Muenchian grouping technique in XSLT 1.0, you can successfully group your data and select distinct values even with the limitations of this version. This approach allows you to efficiently handle XML data without needing to switch to XSLT 2.0. Happy transforming!