Скачать или смотреть Extracting Data from Multiple XML Files Using XSLT with Shared IDs

Learn how to effectively merge and extract data from two XML files using XSLT by leveraging shared ID numbers. This blog outlines a straightforward solution to create separate records based on ID matching.
---
This video is based on the question https://stackoverflow.com/q/72622711/ asked by the user 'IIAND' ( https://stackoverflow.com/u/19338524/ ) and on the answer https://stackoverflow.com/a/72622907/ 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: 2 XML files, 1 XLST: extracting data using shared ID number

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.
---
Extracting Data from Multiple XML Files Using XSLT with Shared IDs

When working with XML files, it's common to have multiple documents that contain related data. An interesting challenge arises when you need to extract and combine this data based on a shared identifier. If you've found yourself needing to extract data from two XML files using a shared ID number, you're in the right place! In this guide, we'll explore how to achieve this using XSLT.

The Challenge

Imagine you have two XML files:

The first file contains titles and ID numbers.

The second file holds subject headings that correspond to those ID numbers.

The goal is to generate an XML output that includes distinct records for each item, incorporating the right subject headings based solely on the shared ID.

Here are the contents of our sample XML files:

XML File 1

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

XML File 2

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

The Solution

To extract the desired data effectively, we will utilize XSLT with a key declaration for cross-referencing the ID numbers. Here’s how we can structure our XSLT to achieve the intended output.

Step 1: Declare a Key

Begin by defining a key that matches the id number in the second XML file:

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

Step 2: Match the Section Template

In the template for the Section, we will create a variable to look up the associated record:

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

Step 3: Output the Subjects

Now, within this template, we can output the subjects associated with each ID number:

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

Example of Resultant XML Output

Your output should now look like this, with separate records for each ID:

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

Conclusion

By following the steps outlined above, you can successfully extract data from multiple XML files based on a shared ID using XSLT. This approach not only improves the readability of your output but also ensures that each record is accurately linked with its associated subjects. Happy coding!