Oxygen XML Forum

Posted: **Tue Dec 22, 2015 5:56 pm**

How can I transfom this xml:

<Objects>

  <object>

    <Property Name="bname">Peter</Property>

    <Property Name="age">12</Property>

    <Property Name="color">

    	<Property>Blu</Property>

    	<Property>Red</Property>

    	<Property>Green</Property>

    </Property>

  </Object>

  <object>

    <Property Name="bname">Samuel</Property>

    <Property Name="age">20</Property>

    <Property Name="color">

    	<Property>Yellow</Property>

    	<Property>Red</Property>

    </Property>

  </Object>

</Objects>

in this xml:

Code: Select all

<Objects>

  <object>

    <bname>Peter</bname>

    <age>12</age>

    <colorAttr>

    	<attrColor colName="color">Blu</attrColor>

    	<attrColor colName="color">Red</attrColor>

    	<attrColor colName="color">Green</attrColor>

    </colorAttr>

  </Object>

  <object>

    <bname>Samuel</bname>

    <age>20</age>

    <colorAttr>

    	<attrColor colName="color">Yellow</attrColor>

    	<attrColor colName="color">Red</attrColor>

    </colorAttr>

  </Object>

</Objects>

Help me. Please.

Posted: **Thu Dec 24, 2015 10:13 am**

Hello,

Below you can find a stylesheet to transform your source XML. You just need to create a transformation scenario and apply it over the source file.
Please note that tour source an destination files that you posted are not well formed. The end tag of the object element is written with uppercase, it is "</Object>" instead of "</object>".

Code: Select all


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

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

    <xsl:output method="xml"/>

    <!-- Match document -->

    <xsl:template match="/">

        <xsl:apply-templates mode="copy" select="."/>

    </xsl:template>

    

    <xsl:template match="Property[@Name='bname']" mode="copy">

        <bname><xsl:apply-templates mode="copy"/></bname>

    </xsl:template>

    

    <xsl:template match="Property[@Name='age']" mode="copy">

        <age><xsl:apply-templates mode="copy"/></age>

    </xsl:template>

    

    <xsl:template match="Property[@Name='color']" mode="copy">

        <colorAttr><xsl:apply-templates mode="copy"/></colorAttr>

    </xsl:template>

    

    <xsl:template match="Property[@Name='color']/Property" mode="copy">

        <attrColor>

            <xsl:attribute name="colName">color</xsl:attribute>

            <xsl:apply-templates mode="copy"/>

        </attrColor>

    </xsl:template>

    

    <!-- Deep copy template -->

    <xsl:template match="*|text()|@*" mode="copy">

        <xsl:copy>

            <xsl:apply-templates mode="copy" select="@*"/>

            <xsl:apply-templates mode="copy"/>

        </xsl:copy>

    </xsl:template>

    <!-- Handle default matching -->

    <xsl:template match="*"/>

</xsl:stylesheet>

Best Regards,
Octavian

Oxygen XML Forum

Help me to trasform xml in another xml

Help me to trasform xml in another xml

Re: Help me to trasform xml in another xml