Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XSLT Help and Discussion
»
XSLT Order "Spliiting" Help
Conferences
Stylus Studio Feature Requests
(1192)
Stylus Studio Technical Forum
(14621)
Website Feedback
(249)
XSLT Help and Discussion
(7625)
Use of before and after string
(3)
How do I substitute element ty...
(1)
How does one add working days ...
(4)
Help, I have existing XLT and...
(1)
Need help on XSLT issue -
(2)
EDI to XML Conversion
(7)
XML To JSON Conversion using X...
(1)
Formatting Paragraphs to same ...
(2)
Grouping of records
(1)
Problems with xsd 1.1
(4)
XML to HL7 mapping
(3)
XSLT 3 and Iterate
(2)
XSL-FO to PDF preview
(3)
java.lang.RuntimeException: Er...
(2)
Create Acroforms with Stylus X...
(2)
How to change XSLT parameter s...
(3)
how to change format of the da...
(2)
Search "Next 8 Results " doesn...
(2)
Support for Git
(1)
newbee
(8)
[1-20]
[21-40]
[41-60]
Next
XQuery Help and Discussion
(2017)
Stylus Studio FAQs
(159)
Stylus Studio Code Samples & Utilities
(364)
Stylus Studio Announcements
(113)
Topic
next
Subject:
XSLT Order "Spliiting" Help
Author:
Jeffrey Lynch
Date:
26 Feb 2005 12:34 AM
I have an inbound document as shown below.
<Orders>
<Order>
<Header OrderNo="123"></Header>
<Line Item="ABC" Date="02-25-2005"></Line>
<Line Item="DEF" Date="02-26-2005"></Line>
<Line Item="YXZ" Date="02-26-2005"></Line>
<Footer NoLines="3"></Footer>
</Order>
</Orders>
I need help creating the map to transform to this if possible:
<Orders>
<Order>
<Header OrderNo="123"></Header>
<Line Item="ABC" Date="02-25-2005"></Line>
<Footer NoLines="1"></Footer>
</Order>
<Order>
<Header OrderNo="123"></Header>
<Line Item="DEF" Date="02-26-2005"></Line>
<Line Item="YXZ" Date="02-26-2005"></Line>
<Footer NoLines="2"></Footer>
</Order>
</Orders>
Basically, I need to split the single <Order></Order> into multiple
<Order></Order> with the same <Header> but with the <Line> items grouped
together by "Date".
next
Subject:
XSLT Order
Author:
Ivan Pedruzzi
Date:
26 Feb 2005 01:11 AM
Jeffrey,
This is a typical grouping problem, here is one of the possible solutions
Hope this helps
Ivan
<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="
http://www.w3.org/1999/XSL/Transform">
<xsl:key name="item" match="Orders/Order/Line" use="@Date"/>
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<Orders>
<xsl:for-each select="Orders/Order/Line">
<xsl:variable name="group" select="key('item', @Date)"/>
<xsl:if test="generate-id($group[1]) = generate-id()">
<Order>
<Header orderNo="{../Header/@OrderNo}"/>
<xsl:for-each select="$group">
<xsl:copy-of select="."/>
</xsl:for-each>
<Footer NoLines="{count($group) }"/>
</Order>
</xsl:if>
</xsl:for-each>
</Orders>
</xsl:template>
</xsl:stylesheet>
top
Subject:
XSLT Order
Author:
Jeffrey Lynch
Date:
26 Feb 2005 10:50 AM
Thanks so much for the help! Your XSLT does exactly what I'm looking for.
Powered by
Stylus Studio
, the world's leading
XML IDE
for
XML
,
XSLT
,
XQuery
,
XML Schema
,
DTD
,
XPath
,
WSDL
,
XHTML
,
SQL/XML
, and
XML Mapping
!
Go to Conference:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.