XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Grouping Problem
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - XSL-fo and how to line feed th... (1)
-> + Houston we have a problem (2)
-> + XSL-FO PDF generation (2)
-> + StylusStudio - pick XSLT 1.0 b... (6)
-> - Stylus Studio 2010 debugging f... (1)
-> - Drop down menu List / Option M... (1)
-> - XML transformation using Java ... (1)
-> + i can't to find XSLT editor in... (2)
-> - Copy xml input as value of an ... (1)
-> - Remove Name space from the Tab... (1)
-> - CGI formatted URL with name/va... (1)
-> - Problem with counting (1)
-> + for-each loop is only returnin... (3)
-> - sort date but some dates may b... (1)
-> - Entity Conversion (1)
-> - How can I build an xml convert... (1)
-> + Little Help (2)
-> + how do I merge nodes to one sc... (2)
-> - beginner help xslt and xpath (1)
-> - Convert XML Feed to CSV/SQL/XL... (1)
-> - Working with text node. (1)
-> - No Topic (1)
-> - API for XSLT Converter for .NE... (1)
-> - Getting started (1)
-> + saxon sql extensions - mysql a... (2)
-> - How do I copy and create new e... (1)
-> + substring-before and sums (3)
-> + Parsing special characters in ... (2)
-> + Schema - Require attribute in ... (2)
-> - Edit existing XSL files when n... (1)
-> + How can I use one single XSLT ... (2)
-> - Default selection of value in ... (1)
-> - Problem with watermark in pdf ... (1)
-> + XSLT Parameter Values dialog n... (3)
-> + Value of File Name is not acce... (10)
-> - Need help with a complex table... (1)
-> - How to replace all nordic char... (1)
-> - XSLT java heap space error wit... (1)
-> - Table Overflow to next page (1)
-> - Using XSLT 2.0 to define custo... (1)
-> - "standalone" attribute and xs... (1)
-> + Standardizing IP addresses (2)
-> + Programmatically changing page... (6)
-> + Can Stylus generate XSLT if so... (5)
-> + Extraction based on NODE Name. (2)
-> + NO XSLT:WYSIWYG (2)
-> + determine condition at run tim... (2)
-> - How to reduce top margin in ev... (1)
-> + need help on xsl looping (4)
-> - Convert Symbol to Element (1)
-> + Separator -only- between field... (3)
-> + DocBook (9)
-> + First Occurance of Alphabet (2)
-> + XSL:Key and Document (2)
-> + Excel Macro using XSLT (2)
-> + Add missing element and attrib... (2)
-> + XSL: Stop Count at First Match (2)
-> + XSD to EDI (4)
-> + How to access data from nested... (2)
-> + Simple division of XML file (2)
-> - XML to Flat File (1)
-> + Dispalying data whith xsl:for ... (3)
-> - distinct nodes - into 3 column... (1)
-> + Newbie at XML (2)
-> + XSL Not Working (3)
-> + to draw table using xsl (2)
-> + Base64 decoder (5)
-> + How to create a hidden sheet u... (3)
-> + XML Reports (2)
-> + Copying image files from one d... (2)
-> + XML conversion to RSS (2)
-> + Inserting Image (2)
-> + Xml to Pdf using Xsl (2)
-> + Using a parameter (or similar)... (2)
-> + How to avoid creating empty xm... (2)
-> + how to read txt files in xml (2)
-> + Limit records to 4 per page. P... (4)
-> + XSLT Mapping Based on JDK5 (2)
-> + XML Mappin (2)
-> + Format Datetime with xslt (3)
-> + Cell border missing (2)
-> + XSL: Key (not matches) (5)
-> + Loop through each char in stri... (2)
-> + What is the best way to sum va... (3)
-> + xslt sort help (2)
-> + getting the count (2)
-> + XSL dynamic variables (5)
-> + XSL:Key use (3)
-> + Help With Updating Attributes ... (8)
-> + GETTING COUNT AND POSITION usi... (3)
-> - Hi Everyone !! (1)
-> + Graph Traversal (Keep track of... (2)
-> + XSL IF with sum (2)
-> + Param not incrementing (2)
-> + Iterating through value tags (3)
-> + URGENT :::: Remove the name sp... (2)
-> + Pass new param values to ASP O... (2)
-> + Detect Browser Version in XSL (2)
-> + xslt result-document (2)
-> + Unique nodes based on two attr... (3)
-- Previous [181-200] [201-220] [221-240] Next
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Bijayananda PandaSubject: Grouping Problem
Author: Bijayananda Panda
Date: 12 Sep 2005 07:31 AM
Hi All,
Can some body help me over the below problem. I am very new to XSLT Mapping.

The Input File is:

<LegacyPayrollRequests>
<LegacyPayrollRequest>
<LegpayNr>111</LegpayNr>
<Betrg>4444.00</Betrg>
</LegacyPayrollRequest>
<LegacyPayrollRequest>
<LegpayNr>222</LegpayNr>
<Betrg>6666.00</Betrg>
</LegacyPayrollRequest>
<LegacyPayrollRequest>
<LegpayNr>111</LegpayNr>
<Betrg>5555.00</Betrg>
</LegacyPayrollRequest>
<LegacyPayrollRequest>
<LegpayNr>222</LegpayNr>
<Betrg>7777.00</Betrg>
</LegacyPayrollRequest>
<LegacyPayrollRequest>
<LegpayNr>333</LegpayNr>
<Betrg>8888.00</Betrg>
</LegacyPayrollRequest>
</LegacyPayrollRequests>

Target Output is:
<REM_SPEC01>
<IDOC BEGIN="1">
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>4444.00</AMOUNT>
</E1BP7012_1>
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>5555.00</AMOUNT>
</E1BP7012_1>
</IDOC>
<IDOC BEGIN="2">
<E1BP7012_1>
<EMPLOYEENUMBER>222</EMPLOYEENUMBER>
<AMOUNT>6666.00</AMOUNT>
</E1BP7012_1>
<E1BP7012_1>
<EMPLOYEENUMBER>222</EMPLOYEENUMBER>
<AMOUNT>7777.00</AMOUNT>
</E1BP7012_1>
</IDOC>
<IDOC BEGIN="3">
<E1BP7012_1>
<EMPLOYEENUMBER>333</EMPLOYEENUMBER>
<AMOUNT>8888.00</AMOUNT>
</E1BP7012_1>
</IDOC>
</REM_SPEC01>

The XSL is:
<?xml version='1.0' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<REM_SPEC01>
<xsl:for-each select="LegacyPayrollRequests/LegacyPayrollRequest">
<IDOC BEGIN="1">
<xsl:attribute name="BEGIN">
<xsl:value-of select="position()"/>
</xsl:attribute>
<E1BP7012_1>
<EMPLOYEENUMBER>
<xsl:value-of select="LegpayNr"/>
</EMPLOYEENUMBER>
<AMOUNT>
<xsl:value-of select="Betrg"/>
</AMOUNT>
</E1BP7012_1>
</IDOC>
</xsl:for-each>
</REM_SPEC01>
</xsl:template>
</xsl:stylesheet>

This XSL generates 5 Idocs as it is. I know there should be some check/grouping logic to be written before <IDOC> and <E1BP7012_1> level.
Can any one help me please.

Thanks.
Bijayananda

Postnext
(Deleted User) Subject: Grouping Problem
Author: (Deleted User)
Date: 12 Sep 2005 08:19 AM
Hi Bijayananda,
can you be more specific about the missing grouping/logic you are referring to? Given the input XML and the requested output, I don't see what's missing in your XSLT stylesheet.

Thanks,
Alberto
Postnext
Bijayananda PandaSubject: Grouping Problem
Author: Bijayananda Panda
Date: 12 Sep 2005 08:49 AM
Hi Alberto,
Thanks for the reply. The current XSL generates 5 Idocs, where as my requirement is to generate only 3 IDocs ( 1st Idoc should club together LegpayNrs of 111, 2nd Idoc should club together LegpayNrs of 222 and 3rd Idoc should contain only legpayNr 333 data).

Present XSL is not doing this grouping, instead, its generating 5 separate Idocs.

Hope, this will help you.

Thanks.
Bijayananda
Postnext
(Deleted User) Subject: Grouping Problem
Author: (Deleted User)
Date: 13 Sep 2005 06:35 AM
Hi Bijayananda,
to do grouping you need to use a key:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="employee" match="LegacyPayrollRequests/LegacyPayrollRequest" use="LegpayNr"/>

<xsl:template match="/">
<REM_SPEC01>
<xsl:for-each select="LegacyPayrollRequests/LegacyPayrollRequest[ generate-id() = generate-id(key('employee', LegpayNr)[1]) ]">
<xsl:variable name="curpayNr" select="LegpayNr"/>
<IDOC BEGIN="{position()}">
<E1BP7012_1>
<EMPLOYEENUMBER>
<xsl:value-of select="LegpayNr"/>
</EMPLOYEENUMBER>
<AMOUNT>
<xsl:value-of select="sum(/LegacyPayrollRequests/LegacyPayrollRequest[LegpayNr=$curpayNr]/Betrg)"/>
</AMOUNT>
</E1BP7012_1>
</IDOC>
</xsl:for-each>
</REM_SPEC01>
</xsl:template>
</xsl:stylesheet>

Hope this helps,
Alberto

Postnext
Bijayananda PandaSubject: Grouping Problem
Author: Bijayananda Panda
Date: 13 Sep 2005 08:08 AM
Dear Alberto,
Thanks for the reply. In the output, i want 3 Idocs, but every Idoc should club together the LegpayNr data including Tags. For example, the 1st Idoc should contain:

<IDOC BEGIN="1">
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>4444.00</AMOUNT>
</E1BP7012_1>
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>5555.00</AMOUNT>
</E1BP7012_1>
</IDOC>


The Required Outpt:
==================
<REM_SPEC01>
<IDOC BEGIN="1">
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>4444.00</AMOUNT>
</E1BP7012_1>
<E1BP7012_1>
<EMPLOYEENUMBER>111</EMPLOYEENUMBER>
<AMOUNT>5555.00</AMOUNT>
</E1BP7012_1>
</IDOC>
<IDOC BEGIN="2">
<E1BP7012_1>
<EMPLOYEENUMBER>222</EMPLOYEENUMBER>
<AMOUNT>6666.00</AMOUNT>
</E1BP7012_1>
<E1BP7012_1>
<EMPLOYEENUMBER>222</EMPLOYEENUMBER>
<AMOUNT>7777.00</AMOUNT>
</E1BP7012_1>
</IDOC>
<IDOC BEGIN="3">
<E1BP7012_1>
<EMPLOYEENUMBER>333</EMPLOYEENUMBER>
<AMOUNT>8888.00</AMOUNT>
</E1BP7012_1>
</IDOC>
</REM_SPEC01>

Thanks.
Bijayananda
Postnext
(Deleted User) Subject: Grouping Problem
Author: (Deleted User)
Date: 14 Sep 2005 03:53 AM
Hi Bijayananda,
if you don't want to sum the paychecks, but just cluster together, you need to iterate over all the elements matching the current employee number, like this:

<xsl:for-each select="/LegacyPayrollRequests/LegacyPayrollRequest[LegpayNr=$curpayNr]">
<E1BP7012_1>
<EMPLOYEENUMBER>
<xsl:value-of select="LegpayNr"/>
</EMPLOYEENUMBER>
<AMOUNT>
<xsl:value-of select="Betrg"/>
</AMOUNT>
</E1BP7012_1>
</xsl:for-each>

Hope this helps,
Alberto
Posttop
Bijayananda PandaSubject: Grouping Problem
Author: Bijayananda Panda
Date: 14 Sep 2005 04:35 AM
Dear Alberto,
Thanks for your help. It worked fine.

Regards.
Bijayananda.
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.