SSDN - how do I merge nodes to one schema

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

c.m. fishman

Subject: how do I merge nodes to one schema
Author: c.m. fishman
Date: 04 Feb 2010 08:47 PM

I have the following:
<ResponseDoc>
<CheckHead>
<CheckNum>12345</CheckNum>
<CheckAmt/>
<CheckPending/>
<VendorNum>abc123</VendorNum>
</CheckHead>
<CheckHead>
<CheckNum>24567</CheckNum>
<CheckAmt/>
<CheckPending/>
<VendorNum>abc123</VendorNum>
</CheckHead>
<CheckHead>
<CheckNum>3567</CheckNum>
<CheckAmt/>
<CheckPending/>
<VendorNum>abc123</VendorNum>
</CheckHead>
<InboundData>
<InCheckNum>24567</InCheckNum>
<InCheckAmt>123.45</InCheckAmt>
</InboundData>
</ResponseDoc>

and need to get the following:

<RequestDoc>
<CheckHead>
<CheckNum>12345</CheckNum>
<CheckAmt/>
<CheckPending/>
<VendorNum>abc123</VendorNum>
</CheckHead>
<CheckHead>
<CheckNum>24567</CheckNum>
<CheckAmt>123.45</CheckAmt>
<CheckPending>true</CheckPending>
<VendorNum>abc123</VendorNum>
</CheckHead>
<CheckHead>
<CheckNum>3567</CheckNum>
<CheckAmt/>
<CheckPending/>
<VendorNum>abc123</VendorNum>
</CheckHead>
</RequestDoc>

I think I have to walk down the Response Doc using for-each. I know I need to create a template and I suspect I need to create keys but I am at a loss at how to put it together ...

I thank you in advance ...
Cathlene

c.m. fishman

Subject: how do I merge nodes to one schema
Author: c.m. fishman
Date: 04 Feb 2010 09:15 PM

I forgot to mention I am using xslt 1.0 ...

thanks ...

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.