XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » converting XML1 to XML2 structure
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Dhanya dSubject: converting XML1 to XML2 structure
Author: Dhanya d
Date: 15 May 2012 05:42 AM
Hi

I am new to XSLT and need your help to assist me.

I have following xml input and need to convert to another XML structure using XSLT .
Please can somebody provide me the XSLT for this conversion.
We have to find the list of EMPID under the CITY node and assign as Location wise alignment.

<?xml version = "1.0" encoding = "UTF-8"?>
<Inputs xmlns = "http://www.asd.com/schemas/Service/Schema.xsd">
<row>
<column>
<name>CITY</name>
<value>DELHI</value>
</column>
<column>
<name>EMPID</name>
<value>87676</value>
</column>
<column>
<name>COMPANY</name>
<value>xyz</value>
</column>
</row>
<row>
<column>
<name>CITY</name>
<value>MUMBAI</value>
</column>
<column>
<name>EMPID</name>
<value>97987</value>
</column>
<column>
<name>COMPANY</name>
<value>abc</value>
</column>
</row>
<row>
<column>
<name>CITY</name>
<value>DELHI</value>
</column>
<column>
<name>EMPID</name>
<value>76767</value>
</column>
<column>
<name>COMPANY</name>
<value>jhkjh</value>
</column>
</row>
<row>
<column>
<name>CITY</name>
<value>MUMBAI</value>
</column>
<column>
<name>EMPID</name>
<value>12334</value>
</column>
<column>
<name>COMPANY</name>
<value>nnbn</value>
</column>
</row>
</Inputs>

and I need to convert it to below xml format using xslt. How to achieve this output. Please can you provide me the XSLT for the same.

<?xml version = "1.0" encoding = "UTF-8"?>
<ns0:output xmlns:ns0 = "http://www.asd.com/schemas/Service/Schema.xsd">
<ns0:Location>
<ns0:City>MUMBAI</ns0:City>
<ns0:Employee>
<ns0:EMPID>97987</ns0:EMPID>
<ns0:company>abc</ns0:company>
</ns0:Employee>
<ns0:Employee>
<ns0:EMPID>12334</ns0:EMPID>
<ns0:company>nnbn</ns0:company>
</ns0:Employee>
</ns0:Location>
<ns0:Location>
<ns0:City>DELHI</ns0:City>
<ns0:Employee>
<ns0:EMPID>87676</ns0:EMPID>
<ns0:company>xyz</ns0:company>
</ns0:Employee>
<ns0:Employee>
<ns0:EMPID>76767</ns0:EMPID>
<ns0:company>jhkjh</ns0:company>
</ns0:Employee>
</ns0:Location>
</ns0:output>

Thanks
Dhanya

Posttop
Ivan PedruzziSubject: converting XML1 to XML2 structure
Author: Ivan Pedruzzi
Date: 15 May 2012 11:25 AM
Could you please send your Stylus Studio installation ID (click Help->About->Installation ID) to stylussupport@ivitechnologies.com?

Thanks
Ivan Pedruzzi
Stylus Studio Team
 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.