Hi, Andy,
It's very possible. Here's one way.
First, here's your source XML snippet with an additional parent element (so
that I could test):
<WRAPPER>
<LIST_CREATION>
<CREATION>
<CREATION_DATE>03-OCT-07</CREATION_DATE>
</CREATION>
</LIST_CREATION>
<LIST_NOTE>
<NOTE>
<OUT_NOTE>Blue Box</OUT_NOTE>
</NOTE>
<NOTE>
<OUT_NOTE>Red Box</OUT_NOTE>
</NOTE>
</LIST_NOTE>
</WRAPPER>
And here's a transform that produces your desired output.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="*"/>
<xsl:template match="WRAPPER">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="LIST_CREATION">
<LIST_COMBINED>
<COMBINED>
<xsl:copy-of select="CREATION/CREATION_DATE"/>
<xsl:copy-of select="../LIST_NOTE/NOTE[1]/OUT_NOTE"/>
</COMBINED>
<COMBINED>
<xsl:copy-of select="../LIST_NOTE/NOTE[position() >
1]/OUT_NOTE"/>
</COMBINED>
</LIST_COMBINED>
</xsl:template>
</xsl:stylesheet>
I can think of other ways to do this (via apply-templates, for one), but
this is one possible way.
I tested with Saxon 8.9.
Jay Bryant
Bryant Communication Services
http://www.bryantcs.com
----- Original Message -----
From: <Andy(_dot_)Lewis(_at_)emerson(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Thursday, January 03, 2008 4:00 PM
Subject: [xsl] xml to xml mapping - how to combine two groups
Hello,
I have the following xml data:
<LIST_CREATION>
<CREATION>
<CREATION_DATE>03-OCT-07</CREATION_DATE>
</CREATION>
</LIST_CREATION>
<LIST_NOTE>
<NOTE>
<OUT_NOTE>Blue Box</OUT_NOTE>
</NOTE>
<NOTE>
<OUT_NOTE>Red Box</OUT_NOTE>
</NOTE>
</LIST_NOTE>
I need to map these into one grouping.
I would like the result to be something like:
<LIST_COMBINED>
<COMBINED>
<CREATION_DATE>03-OCT-07</CREATION_DATE>
<OUT_NOTE>Blue Box</OUT_NOTE>
</COMBINED>
<COMBINED>
<OUT_NOTE>Red Box</OUT_NOTE>
</COMBINED>
</LIST_COMBINED>
If this is possible, I would much appreciate some guidance!!
Thanks! Andy
This message may contain confidential and/or privileged information. This
information is intended to be read only by the individual or entity to whom
it is addressed. If you are not the intended recipient, you are on notice
that any review, disclosure, copying, distribution or use of the contents of
this message is strictly prohibited. If you have received this message in
error, please notify the sender immediately and delete or destroy any copy
of this message.
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--