 |
|
|
Hi,
Actually i didnt much understand the comment by you, i am not a expert in XSL :(. My Problem is as following, i am having the following xml (xml1), which is derived out of some source. The xml is of some company, and it shows the the product sales by department ( Units and Amount). For example, the product AAA in department Manufacturing have units as 500 and amount as 62,823,395. Similar logic works for other department and products.
THe problem is that there are some user configurations, which are different from this xml. Lets say the user wants to just see the units of all the products in the department Manufacturing. I need to take that configuration into the XSL, currently there are two configuration inputs, but there can be more combinations like units and amount for manufacturing or units for both manufacturing and IT. Below is also the kind of xml which will be output in the case of user inputs of manufacturing and units.
The XML1 is generated on the fly and is not stored anywhere.
XML1...........
<table>
<head>
<row>
<cr colspan="1" rowspan="3"/>
<hg-hg colspan="4" rowspan="1" >
<caption caption="Ev"/>
</hg-hg>
</row>
<row>
<c-hg colspan="2" rowspan="1">
<caption caption="Manufacturing"/>
</c-hg>
<c-hg colspan="2" rowspan="1">
<caption caption="IT"/>
</c-hg>
</row>
<row>
<hg-hg colspan="1" rowspan="1">
<caption caption="Product"/>
</hg-hg>
<c-hg colspan="1" rowspan="1">
<caption caption="Units"/>
</c-hg>
<c-hg colspan="1" rowspan="1">
<caption caption="$ Amount"/>
</c-hg>
<c-hg colspan="1" rowspan="1">
<caption caption="Units"/>
</c-hg>
<c-hg colspan="1" rowspan="1">
<caption caption="$ Amount"/>
</c-hg>
</row>
</head>
<body>
<row>
<r-hg colspan="1" indent="1" rowspan="1">
<caption caption="AAA"/>
</r-hg>
<l value="500"/>
<l value="62,823,395"/>
<l value="441"/>
<l value="49,635,600"/>
</row>
<row>
<r-hg colspan="1" indent="1" rowspan="1" style="odd">
<caption caption="BBB"/>
</r-hg>
<l value="921"/>
<l value="283,835,573"/>
<l value="879"/>
<l value="271,281,733"/>
</row>
<row>
<r-hg colspan="1" indent="1" rowspan="1">
<caption caption="CCC"/>
</r-hg>
<l value="487"/>
<l value="64,593,105"/>
<l value="487"/>
<l value="64,716,720"/>
</row>
</body>
</table>
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>
</output>
Please help me get this transformation done. with user inputs. All helps are greatly appreciated.
Thanks
Kunal
|
|
| |
These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.
| |
| |
|
|
|
