SSDN - Grouping In XML

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 15 Aug 2005 04:02 PM
Originally Posted: 15 Aug 2005 02:48 PM

I am a newbie when if comes to XML and XSL and need some advice. I have a situation where I have a water system that may have multiple enforcement actions and violations but I am trying to figure out how to only have the water system number appear once and all of the associated enforcement actions or violations under it. The water system number is the same but if the date or violation number is different it appears multiple times. In Access I can create a report that sorts this but unfortunately when I export the report to XML it separates each instance. Any advice would be helpful.<br> <br> Thanks<br> <br> CJ<br>

Ivan Pedruzzi

Subject: Grouping In XML
Author: Ivan Pedruzzi
Date: 15 Aug 2005 03:21 PM

Carol,
Post a sample of your XML and the desired output and we will show you how.

Ivan Pedruzzi
Stylus Studio Team

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 15 Aug 2005 04:10 PM

I hope this what you are asking for as I said this all new to me.

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 15 Aug 2005 04:16 PM

As I stated I am new to this so hopefully this what you need to help me.

Carol

Violationenforcementassignment.xml

XMLTest.mdb

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 15 Aug 2005 04:27 PM

Sorry for the double post but I didn't think it went through the first time.

Ivan Pedruzzi

Subject: Grouping In XML
Author: Ivan Pedruzzi
Date: 15 Aug 2005 05:18 PM

The attached XSLT generate an HTML report with violations and enforcement actions groupped by water ID.

It should be a good starting point.

Hope this helps
Ivan Pedruzzi
Stylus Studio team

Violationenforcementassignment.xsl

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 16 Aug 2005 08:11 AM

Thank you. If I need further help I will come and visit again. I work from 4:00 am until 2:00 pm so I am sorry I did not thank you sooner.

Carol Hicks

Subject: Grouping In XML
Author: Carol Hicks
Date: 18 Aug 2005 04:53 PM
Originally Posted: 18 Aug 2005 11:27 AM

Your response was very helpful but now it seem they want to do the following. It makes no sense to me as I thought by creating a make table in access to extract all of the needed data it would be much easier but I am not the boss here so here is what he said this morning.<br> <br> In the process of exporting (as an XML file) EnforcementActions from a table in Access, I need to be able to make a pass through a separate table, and extract a field from that table whenever there's a match on a field called ENFID (each table has a field so named).<br> <br> Did I send you all three tables?<br> <br> Carol<br>

Topic Page 1 2 3 4 5 6 7 8 9

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:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.