Index matching on the basis of occurence in a xml

Hi,

Its not that case, I have written one xsl which was working for one case but not for a very generic case. The inputs i am taking about i have appeneded them in the document which are given to the transform api, or for proof of concept i am setting it as a param. I have written the following xsl..

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >

<xsl:output method="xml" indent="yes"/>

<xsl:param name="value" />

<xsl:variable name="c-hg" />

<xsl:template match="/table">

<output>

<delivery>

<xsl:apply-templates select="body/row/r-hg"/>

</delivery>

<xsl:for-each select="head/row[2]/c-hg" >

<xsl:variable name="c-hg" >

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

</xsl:variable>

<xsl:variable name="tempIndex"> <!-- Find index of main header, eg Manufacturing -->

<xsl:for-each select="/table/head/row[2]/c-hg">

<xsl:if test="$c-hg = caption/@caption" >

<xsl:value-of select="position()"/>

</xsl:if>

</xsl:for-each>

</xsl:variable>

<xsl:variable name="dcolspan" >

<xsl:for-each select="/table/head/row[2]/c-hg[1]" >

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

</xsl:for-each>

</xsl:variable>

<xsl:variable name="tempIndex2" select="count((/mdxtable/head/row[3]/c-hg[caption/@caption = $value])[1]/preceding-sibling::*) " />

<xsl:variable name="index">

<xsl:value-of select="$tempIndex2 + ($tempIndex - 1) * $dcolspan"/>

</xsl:variable>

<dataset seriesName="{$c-hg}">

<xsl:apply-templates select="/table/body/row/l[position() = $index]"/>

</dataset>

</xsl:for-each>

</output>

</xsl:template>

<xsl:template match="l">

<set value="{@value}"/>

</xsl:template>

<xsl:template match="r-hg">

<del label="{caption/@caption}"/>

</xsl:template>

</xsl:stylesheet>

This i tried to get the following output xml

<output >

<delivery>

<del label="AAA"/>

<del label="BBB"/>

<del label="CCC"/>

</delivery>

<data seriesName="Manufacturing">

<set value="500"/>

<set value="921"/>

<set value="487"/>

</data>

<data seriesName="IT">

<set value="441"/>

<set value="879"/>

<set value="487"/>

</data>

</output>

The case here is that, if the input xml for a scenario has only manufacturing and it and the colspan for both is 2 and both have units and amount in the second row then this works. But if the layout of the input xml changes this one doesnt work. I tried to have some global params whose values i can retain through the for-each loop but that didnt worked, i also tried having expr attribute with param, but my transform api gave the exception that expr is not allowed with param, in some cases i got the exception that params are not allowed.

I have been working with this kind of approches, please have a look and suggest me how to move fwd.

Thanks a lot.

Regards

Kunal

kunaljain18na at 2007-7-12 19:38:20 >

Hi,

The input XML is based on result of some db queries which uses joins to fetch certain data, this comes from a different component. Now my task is to parse this xml and get the result out. In some cases the joins result are different but will be governed by the colspan for the depts. Like manufacturing have a colspan of 2, IT 1, and inventory 3. So in the second row, baring the first column, the first 2 (units and amount) belong to manufacturing, 3rd (Units) belong to IT and 4th, 5th 6th (Units, cost and Amount) belongs to inventory. This gives the order in which the values will be there in the body of the xml. No i have to take out certain things out of this xml, like to show how much is the individual amount is there for all or how much are the individual units for all three, These are the permutatin combination in which i require the result.

It is not having that value is because the joins doesnt yields that or its not of use. So if some dept doesnt have any value, that dept has to be ignored.

The main problem which i am facing here is to have certain global variable/param whose values are retained through the for-each loops, and making certain flags which check whether the certain value (unit, amount, cost) existed for the depts or not. I am not able to get this done.

Thanks

Kunal

kunaljain18na at 2007-7-12 19:38:20 >