1
Films sample.xml
2
OMDB_data.xml
3
Initial file.xsl

1
<?xml version="1.0" encoding="UTF-8"?>
2
<root>
3
    <movie>
4
        <title></title>
5
        <overview></overview>
6
        <imdbid></imdbid>
7
        <writer></writer>
8
        <director></director>
9
        <cast>
10
            <cast-member firstName="" lastName="">
11
                <character firstName="" lastName=""/>
12
            </cast-member>
13
            <cast-member firstName="" lastName="">
14
                <character firstName="" lastName=""/>
15
            </cast-member>
16
        </cast>
17
        <showing-in>
18
            <cinema></cinema>
19
            <cinema></cinema>
20
        </showing-in>
21
    </movie>
22
</root>

1
<?xml version="1.0" ?>
2
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
3
    <xsl:output omit-xml-declaration="no" method="xml" encoding="UTF-8" indent="yes"/>
4
    <!-- remove whitespace-only text nodes from input so copies won't include blank lines -->
5
    <xsl:strip-space elements="*"/>
6

7
    <xsl:template match="root">
8
        <root>
9
            <xsl:apply-templates select="results"/>
10
        </root>
11
    </xsl:template>
12

13
    <xsl:template match="results">
14
        <!-- For each results node in the films sample.xml create a movie element
15
             and pull matching data from OMDB_data.xml (by title) -->
16
        <movie>
17
            <!-- title and overview from the films sample.xml -->
18
            <title><xsl:value-of select="normalize-space(title)"/></title>
19
            <overview><xsl:value-of select="normalize-space(overview)"/></overview>
20

21
            <!-- find matching movie in OMDB_data.xml by title attribute -->
22
            <xsl:variable name="curTitle" select="normalize-space(title)"/>
23
            <xsl:variable name="omdb" select="document('OMDB_data.xml')/root/movie[normalize-space(@title) = $curTitle]"/>
24

25
            <!-- imdbid, writer and director from OMDB_data.xml -->
26
            <imdbid><xsl:value-of select="$omdb/@imdbID"/></imdbid>
27
            <writer><xsl:value-of select="$omdb/@writer"/></writer>
28
            <director><xsl:value-of select="$omdb/@director"/></director>
29

30
            <!-- build cast explicitly: copy only cast-member attributes and element children (no text nodes) -->
31
            <cast>
32
                <xsl:for-each select="cast/cast-member">
33
                    <xsl:element name="cast-member">
34
                        <xsl:copy-of select="@*"/>
35
                        <!-- copy only element children (e.g., character) to avoid whitespace-only text nodes -->
36
                        <xsl:copy-of select="*"/>
37
                    </xsl:element>
38
                </xsl:for-each>
39
            </cast>
40

41
            <xsl:copy-of select="showing-in"/>
42
        </movie>
43
    </xsl:template>
44

45
</xsl:stylesheet>