Creating new XML using XSLT

nelly78 · August 26th, 2010, 11:06 AM

Hi All,

I Have below xml using XSLT I want to create new xml based on the node name passed in xpath.

Code:

<?xml version="1.0" standalone="yes"?>
<DataSet> 
    <Orders>
        <SalesOrderID>43659</SalesOrderID>
        <SalesOrderDetailID>1</SalesOrderDetailID>
        <CarrierTrackingNumber>4911-403C-98</CarrierTrackingNumber>
        <OrderQty>1</OrderQty>
        <ProductID>776</ProductID>
        <SpecialOfferID>1</SpecialOfferID>
        <UnitPrice>2024.994</UnitPrice>
        <UnitPriceDiscount>0.0000</UnitPriceDiscount>
        <LineTotal>2024.994000</LineTotal>
        <rowguid>b207c96d-d9e6-402b-8470-2cc176c42283</rowguid>
        <ModifiedDate>2001-07-01T00:00:00+01:00</ModifiedDate>
    </Orders>
    <Orders>
        <SalesOrderID>43659</SalesOrderID>
        <SalesOrderDetailID>2</SalesOrderDetailID>
        <CarrierTrackingNumber>4911-403C-98</CarrierTrackingNumber>
        <OrderQty>3</OrderQty>
        <ProductID>777</ProductID>
        <SpecialOfferID>1</SpecialOfferID>
        <UnitPrice>2024.994</UnitPrice>
        <UnitPriceDiscount>0.0000</UnitPriceDiscount>
        <LineTotal>6074.982000</LineTotal>
        <rowguid>7abb600d-1e77-41be-9fe5-b9142cfc08fa</rowguid>
        <ModifiedDate>2001-07-01T00:00:00+01:00</ModifiedDate>
    </Orders>
 </Orders>
</DataSet>

I want XSlt to produce XML like below:

Code:

<?xml version="1.0" standalone="yes"?>
<DataSet> 
    <Orders>
        <SalesOrderID>43659</SalesOrderID>
        <SalesOrderDetailID>1</SalesOrderDetailID>
        <CarrierTrackingNumber>4911-403C-98</CarrierTrackingNumber>        
    </Orders>
    <Orders>
        <SalesOrderID>43659</SalesOrderID>
        <SalesOrderDetailID>2</SalesOrderDetailID>
        <CarrierTrackingNumber>4911-403C-98</CarrierTrackingNumber>        
    </Orders>
 </Orders>
</DataSet>

I am trying to write XSLT like below

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> 
    <xsl:template match="/DataSet"> 
        <xsl:element name="NewDataSet">             
            <xsl:copy-of select="Orders[name()='SalesOrderID' or name()='SalesOrderDetailID' or name()='CarrierTrackingNumber' ]"/>                 
            </xsl:element>
    </xsl:template> 
</xsl:stylesheet>

Based on the node name I want to filter the records.

Please can you correct the xslt what I am doing wrong?

Thanks

Nelly

Martin Honnen · August 26th, 2010, 11:14 AM

For such tasks start with the identity transformation and then add templates for those elements you want to change:

Code:

<xsl:template match="@* | node()">
  <xsl:copy>
     <xsl:apply-templates select="@* | node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="Orders">
  <xsl:copy>
     <xsl:apply-templates select="@* | SalesOrderID | SalesOrderDetailID | CarrierTrackingNumber"/>
   </xsl:copy>
</xsl:template>

You might want to add xsl:output indent="yes" and xsl:strip-space elements="*" for indentation.

samjudson · August 26th, 2010, 11:15 AM

name() will return 'Orders' in the predicate you have there as that is the name of the element it is currently in.

You probably want to start with an identity template:

Code:

<xsl:template match="@*|node()">
  <xsl:copy>
    <xsl:apply-templates select="@*|node()"/>
  </xsl:copy>
</xsl:template>

Then handle the DataSet element:

Code:

<xsl:template match="DataSet">
<NewDataSet>
<xsl:apply-templates/>
</NewDataSet>
</xsl:templates>

Finally handle the Orders element:

Code:

<xsl:template match="Orders">
 <Orders>
    <xsl:apply-templates select="SalesOrderID | SalesOrderDetailID | CarrierTrackingNumber"/>
  </Orders>
</xsl:template>

nelly78 · August 26th, 2010, 11:31 AM

Thank you very much Sam.

It works.

nelly78 · December 21st, 2010, 08:45 AM

Hi All,

Could you please tell me how can I sort the XML result. For example I want resord to be sort by 'SalesOrderID'.

How can I do that?

Thanks
Nelly

mhkay · December 21st, 2010, 09:06 AM

Add the template rule:

Code:

<xsl:template match="DataSet">
  <xsl:copy>
     <xsl:apply-templates select="Orders">
        <xsl:sort select="SalesOrderID"/>
     </xsl:apply-templates>
   </xsl:copy>
</xsl:template>

When I see questions like this, I always wonder where you looked to find this information before asking. Surely any XSLT reference book has "sorting" in the index? And surely you're not coming to a Wrox forum for help without having a Wrox textbook sitting on your desk?