Re: [xsl] Help with transforming unique set of data in XSLT 2.0

Subject: Re: [xsl] Help with transforming unique set of data in XSLT 2.0
From: Michael Kay <mike@xxxxxxxxxxxx>
Date: Tue, 27 Jul 2010 09:05:33 +0100
On 27/07/2010 08:29, Jack Bush wrote:
Hi All,

I am having difficulty get the following stylesheet to transform unique set of
data once:

The fact that your output shows two XML declarations suggests that there is something wrong with the way you are running the transformation or displaying the results. There's no way the XSLT code you have shown will produce two separate result documents, each with its own XML declaration.

Incidentally, the argument to document() should be a URI, not a Windows filename. Many processors let you get away with this error, but there's nothing in the language spec to encourage this and it won't work with all processors.

Michael Kay
Saxonica

The following output generated duplicated set of identical transformed data when
using<xsl:for-each>:

<?xml version="1.0" encoding="UTF-8"?>
<employee>
   <first_name>John</first_name>
   <surname>smith</surname>
   <sex>M</sex>
   <first_name>Kelly</first_name>
   <surname>Jones</surname>
   <sex>F</sex>
</employee>

<?xml version="1.0" encoding="UTF-8"?>
<employee>
   <first_name>John</first_name>
   <surname>smith</surname>
   <sex>M</sex>
   <first_name>Kelly</first_name>
   <surname>Jones</surname>
   <sex>F</sex>
</employee>

I tried the following changes after suspecting that the cause was from the
<xsl:for-each>  statement:

1<xsl:template match="/">
2<xsl:apply-templates select="document('E:/employee.xml')/ns:html"/>
3</xsl:template>
4
5<xsl:template match="ns:html">
6<employee>
7<xsl:variable name="employee_data"
select="ns:body/ns:div[@id='content']/ns:table[@class='sresults']/ns:tr/ns:td/ns:a"/>

8<xsl:apply-templates select="$employee_data"/>
9<first_name><xsl:value-of
select="substring-before(@title,',')"/></first_name>
10<surname><xsl:value-of select="@href"/></surname>
11<sex><xsl:value-of select="@gender"/></sex>
12</employee>
13</xsl:template>

Below is the output without using<xsl:for-each>:

<?xml version="1.0" encoding="UTF-8"?>
<employee>
   John Kelly
   <firstname />
   <surname />
   <sex/>>
</employee>

<?xml version="1.0" encoding="UTF-8"?>
<employee>
   John Kelly
   <firstname />
   <surname />
   <sex/>>
</employee>

Any ideas on what is causing the duplications and why is the second stylesheet
picking up the firstnames of 2 separate xml documents in the wrong place?

The desire output is just a single entry of each record such as the following:

<?xml version="1.0" encoding="UTF-8"?>
<employee>
   <first_name>John</first_name>
   <surname>smith</surname>
   <sex>M</sex>
   <first_name>Kelly</first_name>
   <surname>Jones</surname>
   <sex>F</sex>
</employee>

Thanks a lot,

Jack

Current Thread