SSDN - XSLT Help Needed

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

A Thomas

Subject: XSLT Help Needed
Author: A Thomas
Date: 17 Aug 2008 05:33 PM

Hi ,

I am new to xslt and need help with converting the following xml into the following format. Can you please advise.
-----------------------------
Source XML:
-----------------------------

<Records>
<ROWID rowid=1>
<ROW>
<FieldName>Sr Num</FieldName>
<Value>1234</Value>
</ROW>
<ROW>
<FieldName>First Name</FieldName>
<Value>John</Value>
</ROW>
<ROW>
<FieldName>Last Name</FieldName>
<Value>King</Value>
</ROW>
<ROW>
<FieldName>Age</FieldName>
<Value>24</Value>
</ROW>
<ROW>
<FieldName>City</FieldName>
<Value>San Jose</Value>
</ROW>
<ROW>
<FieldName>State</FieldName>
<Value>CA</Value>
</ROW>

</ROWID>
<ROWID rowid=2>
<ROW>
<FieldName>Sr Num</FieldName>
<Value>3456</Value>
</ROW>
<ROW>
<FieldName>First Name</FieldName>
<Value>Mike</Value>
</ROW>
<ROW>
<FieldName>Last Name</FieldName>
<Value>Tuscun</Value>
</ROW>
<ROW>
<FieldName>Age</FieldName>
<Value>55-</Value>
</ROW>
<ROW>
<FieldName>City</FieldName>
<Value>San Francisco</Value>
</ROW>
<ROW>
<FieldName>State</FieldName>
<Value>CA</Value>
</ROW>

</ROWID>
</Records>
-----------------------------
Destination XML to be converted to:
-----------------------------

<ROWID rowid=1>
<Sr Num>1234</Sr Num>
<First Name>1234</First Name>
<Last Name>1234</Last Name>
<Age>24</Age>
<City>San Jose</City>
<State>CA</State>
</ROWID>
<ROWID rowid=2>
<Sr Num>3456</Sr Num>
<First Name>1234</First Name>
<Last Name>1234</Last Name>
<Age>55</Age>
<City>San Francisco</City>
<State>CA</State>
</ROWID>

A Thomas

Subject: XSLT Help Needed
Author: A Thomas
Date: 18 Aug 2008 11:37 AM

Hi Friends. I really need help with this . Any advice anyone could provide will be helpful.

Minollo I.

Subject: XSLT Help Needed
Author: Minollo I.
Date: 18 Aug 2008 11:47 AM

Have you tried using Stylus Studio mapper? It should make this mapping as easy as drawing a few lines between source and target XML structures: http://www.stylusstudio.com/xslt_mapper.html

A Thomas

Subject: XSLT Help Needed
Author: A Thomas
Date: 18 Aug 2008 11:44 PM

Thanks for the tip. I will try to use Mapper to find a solution.

Topic Page 1 2 3 4 5 6 7 8 9

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.