Combinar diferentes productos pertenecen a cada estándar
Tengo que transformar el siguiente contenido xml,
<Standards xmlns="http://ws.wso2.org/dataservice">
<Standard>
<ProductID>200057</ProductID>
<Prefix>ISO</Prefix>
<SNumber>1001</SNumber>
<DraftProducts>
<RelatedProduct>
<ProductID>1500163</ProductID>
</RelatedProduct>
</DraftProducts>
<ReferenceProducts>
<RelatedProduct>
<ProductID>263973</ProductID>
<RelationId>708519</RelationId>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID>320056</ProductID>
<RelationId>934789</RelationId>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</ReferenceProducts>
<RelatedIntProducts>
<RelatedProduct>
<ProductID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<RelationId>116881</RelationId>
<Relationship>Identical</Relationship>
<Designation>NEN ISO 1001</Designation>
</RelatedProduct>
<RelatedProduct>
<ProductID>208076</ProductID>
<RelationId>116886</RelationId>
<Relationship>Identical</Relationship>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</RelatedIntProducts>
<S1>1001</S1>
<S2>1986</S2>
</Standard>
<Standard>
<ProductID>200058</ProductID>
<Prefix>ISO</Prefix>
<SNumber>1002</SNumber>
<DraftProducts>
<RelatedProduct>
<ProductID>1500167</ProductID>
</RelatedProduct>
</DraftProducts>
<ReferenceProducts>
<RelatedProduct>
<ProductID>263974</ProductID>
<RelationId>708519</RelationId>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID>320052</ProductID>
<RelationId>934754</RelationId>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</ReferenceProducts>
<RelatedIntProducts>
<RelatedProduct>
<ProductID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<RelationId>116837</RelationId>
<Relationship>Identical</Relationship>
<Designation>NEN ISO 1001</Designation>
</RelatedProduct>
<RelatedProduct>
<ProductID>208074</ProductID>
<RelationId>116843</RelationId>
<Relationship>Identical</Relationship>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</RelatedIntProducts>
<S1>1005</S1>
<S2>1983</S2>
</Standard>
</Standards>
en este formato de salida,
<Standards xmlns="http://ws.wso2.org/dataservice">
<Standard>
<ProductID>200057</ProductID>
<Prefix>ISO</Prefix>
<SNumber>1001</SNumber>
<RelatedProducts>
<RelatedProduct>
<ProductID>1500163</ProductID>
<RelationType>DraftProducts</RelationType>
</RelatedProduct>
<RelatedProduct>
<ProductID>263973</ProductID>
<RelationId>708519</RelationId>
<RelationType>ReferenceProducts</RelationType>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID>320056</ProductID>
<RelationId>934789</RelationId>
<RelationType>ReferenceProducts</RelationType>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<RelationId>116881</RelationId>
<Relationship>Identical</Relationship>
<RelationType>RelatedIntProducts</RelationType>
<Designation>NEN ISO 1001</Designation>
</RelatedProduct>
<RelatedProduct>
<ProductID>208076</ProductID>
<RelationId>116886</RelationId>
<RelationType>RelatedIntProducts</RelationType>
<Relationship>Identical</Relationship>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</RelatedProducts>
<S1>1001</S1>
<S2>1986</S2>
</Standard>
<Standard>
<ProductID>200058</ProductID>
<Prefix>ISO</Prefix>
<SNumber>1002</SNumber>
<RelatedProducts>
<RelatedProduct>
<ProductID>1500167</ProductID>
<RelationType>DraftProducts</RelationType>
</RelatedProduct>
<RelatedProduct>
<ProductID>263974</ProductID>
<RelationId>708519</RelationId>
<RelationType>ReferenceProducts</RelationType>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID>320052</ProductID>
<RelationId>934754</RelationId>
<RelationType>ReferenceProducts</RelationType>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
<RelatedProduct>
<ProductID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<RelationId>116837</RelationId>
<RelationType>RelatedIntProducts</RelationType>
<Relationship>Identical</Relationship>
<Designation>NEN ISO 1001</Designation>
</RelatedProduct>
<RelatedProduct>
<ProductID>208074</ProductID>
<RelationId>116843</RelationId>
<RelationType>RelatedIntProducts</RelationType>
<Relationship>Identical</Relationship>
<Designation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
</RelatedProduct>
</RelatedProducts>
<S1>1005</S1>
<S2>1983</S2>
</Standard>
</Standards>
He usado el siguiente xslt, pero todavía no da el resultado esperado. El xslt dado funciona solo cuando hay un estándar. Pero con múltiples estándares, da resultados duplicados debido a la plantilla xsl que utilicé aquí.
<?xml version="1.0" encoding="UTF-8"?>
<!-- When matching RelatedIntProducts: do nothing -->
<xsl:template match="//x:Standards/x:Standard/x:DraftProducts" />
<xsl:template match="//x:Standards/x:Standard/x:RelatedIntProducts" />
<xsl:template match="//x:Standards/x:Standard/x:SupersdProducts" />
<xsl:template match="//x:Standards/x:Standard/x:LinkProducts" />
<xsl:template match="//x:Standards/x:Standard/x:ReferenceProducts">
<RelatedProducts>
<xsl:for-each select="//x:Standards/x:Standard/*/x:RelatedProduct">
<RelatedProduct>
<ProductID>
<xsl:value-of select="x:ProductID">
</xsl:value-of>
</ProductID>
<RelationId>
<xsl:value-of select="x:RelationId">
</xsl:value-of>
</RelationId>
<RelationType>
<xsl:value-of select="name(..)" />
</RelationType>
</RelatedProduct>
</xsl:for-each>
</RelatedProducts>
</xsl:template>
</xsl:stylesheet>
Para cada estándar, necesito fusionar todos los diferentes tipos de productos relacionados en una lista llamada productos relacionados. También necesito mantener las otras cosas como están. ¿Podrías ayudarme a lograr esto?