Xml to Xml: How to group depending on two atributes?

[Filipe]

Hi all,
This is a urgent situation. I´m counting on you guys to
give some clue to get the right XSL Transformation.
I need do group all nested tags <Entry> inside tag
<Record> according to an unique combination of two
atributes ('Product' and 'Customer'). Something like: for
each concatenation of 'Product' and 'Customers' find all
<Entry> because this last tag as different 'Periods'

ORIGINAL XML (with lots of <Records>):

<HistoricSales>
<Record Product="1053865" Customer="10127876">
<Entry Period="6">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
</Record>
<Record Product="1053865" Customer="10127876">
<Entry Period="2">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
</Record>
<Record Product="1022222" Customer="0999999">
<Entry Period="3">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
</Record>
(...)
</HistoricSales>

FINAL XML:

<HistoricSales>
<Record Product="1053865" Customer="10127876">
<Entry Period="6">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
<Entry Period="2">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
</Record>
<Record Product="1022222" Customer="0999999">
<Entry Period="3">
<Units Sold="0" Free="0" Return="0"/>
<Amounts Cost="0" Gross="0" Return="0"/>
</Entry>
</Record>
(...)
</HistoricSales>

At this moment I trying Muenchian Method. Is this the
best way. Thanks in advance.

[Oleg Tkachenko]

Filipe wrote:

This is a urgent situation. I´m counting on you guys to
give some clue to get the right XSL Transformation.
I need do group all nested tags <Entry> inside tag
<Record> according to an unique combination of two
atributes ('Product' and 'Customer'). Something like: for
each concatenation of 'Product' and 'Customers' find all
<Entry> because this last tag as different 'Periods' At this moment I trying Muenchian Method. Is this the
best way. Thanks in advance.

Sure this is the best way in XSLT 1.0. It's as simple as

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="recordKey" match="Record" use="concat(@Product,'|',
@Customer)"/>
<xsl:template match="HistoricSales">
<HistoricSales>
<xsl:apply-templates
select="Record[count(.|key('recordKey',concat(@Product,'|',@Custo mer))[1])=1]"/>
</HistoricSales>
</xsl:template>
<xsl:template match="Record">
<Record>
<xsl:copy-of
select="@*|key('recordKey',concat(@Product,'|',@Cu stomer))"/>
</Record>
</xsl:template>
</xsl:stylesheet>
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Filipe]

Thank you very much Oleg.
This is definitly the solution for me.
Thank you again for your effort even if it's was simple
solution.

PS: Peace to Israel

-----Original Message-----
Filipe wrote:

This is a urgent situation. I´m counting on you guys to give some clue to get the right XSL Transformation.
I need do group all nested tags <Entry> inside tag
<Record> according to an unique combination of two
atributes ('Product' and 'Customer'). Something like: for each concatenation of 'Product' and 'Customers' find all <Entry> because this last tag as different 'Periods'

At this moment I trying Muenchian Method. Is this the
best way. Thanks in advance.

Sure this is the best way in XSLT 1.0. It's as simple as

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="recordKey" match="Record"

use="concat(@Product,'|', @Customer)"/>
<xsl:template match="HistoricSales">
<HistoricSales>
<xsl:apply-templates
select="Record[count(.|key('recordKey',concat (@Product,'|',@Customer))[1])=1]"/> </HistoricSales>
</xsl:template>
<xsl:template match="Record">
<Record>
<xsl:copy-of
select="@*|key('recordKey',concat (@Product,'|',@Customer))"/> </Record>
</xsl:template>
</xsl:stylesheet>
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

.