Tricky XSLT Transformation

Hi all,

I am attempting to create an xslt transformation which I am having trouble with. I am fairly new to xslt and am having a hard time getting my head around it. The original xml file looks like this:

Expand|Select|Wrap|Line Numbers

 <DataSet ID="-5480">

    <ObsGroup>

        <ClsItem name="AGE">2099</ClsItem>

        <ClsItem name="COMB_DATA">20</ClsItem>

        <ClsItem name="SEX">2</ClsItem>

        <ClsItem name="STATE">0</ClsItem>

        <ClsItem name="MARITAL_STATUS">3</ClsItem>

        <ParItem name="UNEMPLOYMENT_RATE">23.34</ParItem>

        <ParItem name="LABFORCE_FULL_TIME">2292.7071594375</ParItem>

        <TimeItem name="TIME_CODE">2447</TimeItem>

    </ObsGroup>

    <ObsGroup>

        <ClsItem name="AGE">2099</ClsItem>

        <ClsItem name="COMB_DATA">20</ClsItem>

        <ClsItem name="SEX">2</ClsItem>

        <ClsItem name="STATE">0</ClsItem>

        <ClsItem name="MARITAL_STATUS">3</ClsItem>

        <ParItem name="UNEMPLOYMENT_RATE">23.66</ParItem>

        <ParItem name="LABFORCE_FULL_TIME">2300.72108466884</ParItem>

        <TimeItem name="TIME_CODE">2451</TimeItem>

    </ObsGroup>

    <ObsGroup>

        <ClsItem name="AGE">2099</ClsItem>

        <ClsItem name="COMB_DATA">20</ClsItem>

        <ClsItem name="SEX">2</ClsItem>

        <ClsItem name="STATE">0</ClsItem>

        <ClsItem name="MARITAL_STATUS">4</ClsItem>

        <ParItem name="UNEMPLOYMENT_RATE">23.77</ParItem>

        <ParItem name="LABFORCE_FULL_TIME">2353.4791599122</ParItem>

        <TimeItem name="TIME_CODE">2447</TimeItem>

    </ObsGroup>

    <ObsGroup>

        <ClsItem name="AGE">2099</ClsItem>

        <ClsItem name="COMB_DATA">20</ClsItem>

        <ClsItem name="SEX">2</ClsItem>

        <ClsItem name="STATE">0</ClsItem>

        <ClsItem name="MARITAL_STATUS">4</ClsItem>

        <ParItem name="UNEMPLOYMENT_RATE">23.88</ParItem>

        <ParItem name="LABFORCE_FULL_TIME">2335.71727933868</ParItem>

        <TimeItem name="TIME_CODE">2451</TimeItem>

    </ObsGroup>

</DataSet>

And I want the transformation to group by the clsitem and one paritem per group, as 'measures'. This group will then have all the timeitem elements related to it. Example output:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<GenericData>

    <DataSet>

        <Series>

            <SeriesKey>    

                <Value concept="MEASURES" value="UNEMPLOYMENT_RATE"/>

                <Value concept="AGE" value="2099"/>

                <Value concept="COMB_DATA" value="20"/>

                <Value concept="SEX" value="2"/>

                <Value concept="STATE" value="0"/>

                <Value concept="MARITAL_STATUS" value="3"/>

            </SeriesKey>

            <Obs>

                <Time>2447</Time>

                <ObsValue value="23.34"/>

            </Obs>

            <Obs>

                <Time>2451</Time>

                <ObsValue value="23.66"/>

            </Obs>

        </Series>

        <Series>

            <SeriesKey>

                <Value concept="MEASURES" value="LABFORCE_FULL_TIME"/>

                <Value concept="AGE" value="2099"/>

                <Value concept="COMB_DATA" value="20"/>

                <Value concept="SEX" value="2"/>

                <Value concept="STATE" value="0"/>

                <Value concept="MARITAL_STATUS" value="3"/>

            </SeriesKey>

            <Obs>

                <Time>2477</Time>

                <ObsValue value="2292.7071594375"/>

            </Obs>

            <Obs>

                <Time>2451</Time>

                <ObsValue value="2300.72108466884"/>

            </Obs>

        </Series>

        <Series>

            <SeriesKey>

                <Value concept="MEASURES" value="UNEMPLOYMENT_RATE"/>

                <Value concept="AGE" value="2099"/>

                <Value concept="COMB_DATA" value="20"/>

                <Value concept="SEX" value="2"/>

                <Value concept="STATE" value="0"/>

                <Value concept="MARITAL_STATUS" value="4"/>

            </SeriesKey>

            <Obs>

                <Time>2447</Time>

                <ObsValue value="23.77"/>

            </Obs>

            <Obs>

                <Time>2451</Time>

                <ObsValue value="23.88"/>

            </Obs>

        </Series>        

        <Series>

            <SeriesKey>

                <Value concept="MEASURES" value="LABFORCE_FULL_TIME"/>

                <Value concept="AGE" value="2099"/>

                <Value concept="COMB_DATA" value="20"/>

                <Value concept="SEX" value="2"/>

                <Value concept="STATE" value="0"/>

                <Value concept="MARITAL_STATUS" value="4"/>

            </SeriesKey>

            <Obs>

                <Time>2447</Time>

                <ObsValue value="2353.4791599122"/>

            </Obs>

            <Obs>

                <Time>2451</Time>

                <ObsValue value="2335.71727933868"/>

            </Obs>

        </Series>

    </DataSet>

</GenericData>

My xslt is not grouping them correctly and I think I am on the wrong path. I have tried several grouping functions also, but they don't look right. My closest useful attempt:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions">

    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

    <xsl:template match="/">

    <GenericData >

    <DataSet>

    <xsl:for-each select="DataSet/ObsGroup/ParItem">

        <Series>

            <SeriesKey>

                <Value>

                   <xsl:attribute name="concept">MEASURES</xsl:attribute>

                   <xsl:attribute name="value"><xsl:value-of select="@name" /></xsl:attribute>               

                </Value>

                <xsl:for-each select="../ClsItem">

                <Value>

                   <xsl:attribute name="concept"><xsl:value-of select="@name" /></xsl:attribute>

                   <xsl:attribute name="value"><xsl:value-of select="." /></xsl:attribute>               

                </Value>                

                </xsl:for-each>

                <xsl:for-each select="../TimeItem">

                   <Obs>

                      <Time><xsl:value-of select="." /></Time>

                      <ObsValue>

                         <xsl:attribute name="value"><xsl:value-of select="../ParItem" /></xsl:attribute>

                      </ObsValue>

                   </Obs>

                </xsl:for-each>

            </SeriesKey>

        </Series>

    </xsl:for-each>

    </DataSet>

    </GenericData>

    </xsl:template>

</xsl:stylesheet>

Which doesn't group the time elements and also doesn't select the proper paritem value in the for-each loop.

I am not sure how I should be approaching this. Anyone have any thoughts?

Jan 15 '10 #1

Subscribe Post Reply

2188

Dormilich

8,658

Expert Mod 8TB

I think, you need something like Munchian Grouping …

Jan 15 '10 #2

Similar topics

xslt transformation with php

by: Sergio del Amo | last post by:

Hi, I use the xslt functions provided by php. I am running in my computer the package xampp(www.apachefriends.org) which includes php/apache/mysql .. In this package the php includes the sablotron...

PHP

XSLT - Help!

by: Pete | last post by:

I am just getting to grips with XML and I was wondering if you could help me with something that no-one seems able or willing to help with.. I have an XSLT file which should be transforming a...

.NET Framework

Using XSLT and XPath for graph data structure processing?

by: Ramon M. Felciano | last post by:

Helo all -- I'm trying to gain a deeper understand for what type of semi-declarative programming can be done through XML and XPath/XSLT. I'm looking at graph processing problems as a testbed for...

.NET Framework

Web service throwing XML - XSLT transformation, how?

by: gipsy boy | last post by:

Hello, I have sort of a big problem. I would really appreciate any help you could give me. I made a web service in C++ that throws XML to the client (browser). But, the XSLT transormation...

.NET Framework

FOP, XSLT: problems with SAX2DTM Parsing trying to convert to XSL-FO in Java

by: Jens Mueller | last post by:

Hi there, this is a Java-XML Question, so I am not sure whether this is the right place, haven't found anything better .... I try to convert a Java object to XML via SAX and let the FOP...

.NET Framework

ajax, xml and applying xslt

by: Stephen | last post by:

I have the following that outputs an xml file to a div using ajax: <script type="text/javascript"> function ajaxXML(url,control_id){ if (document.getElementById) { var x =...

Javascript

Generating XSL:FO from XSLT (and XML)

by: shauldar | last post by:

Is there a way (tool, hack...) to create an XSL:FO from an XSLT + XML files? My motivation is that we want to use a tool to design reports, and from that "design" generate both HTML (via XSLT)...

.NET Framework

XSLT Using Firefox 1.5.0.7

by: simon.a.hulbert | last post by:

Hi, I'm trying to view the following xslt transformation using firefox <xsl:stylesheet xmlns:xsl = "http://www.w3.org/1999/XSL/Transform" version = "1.0" > <xsl:output method = "xml" indent =...

.NET Framework

XSLT in Mozilla using parameters

by: Jonny B | last post by:

Hi all, I'm working on an a clientside xslt using jscript that passes a parameter to the xsl. I've got it working no problem in IE but cant get it to work in Mozilla. Can anyone help? This is...

XML

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA