[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Combining nodes

Subject: RE: Combining nodes
From: "Bordeman, Chris" <Chris.Bordeman@xxxxxxxxxxxxxxxxx>
Date: Thu, 6 Nov 2008 09:22:36 -0600
RE:  Combining nodes
I CAN use XSLT 2.0 and would prefer to do so.

Here is a sample input XML:

<?xml version="1.0"?>
<Input>
	<Fees>
      <Fee>
        <Code>title</Code>
        <Amount>5.00</Amount>
        <IsPublicOfficial>true</IsPublicOfficial>
      </Fee>
      <Fee>
        <Code>license</Code>
        <Amount>10.00</Amount>
        <IsPublicOfficial>true</IsPublicOfficial>
      </Fee>
      <Fee>
        <Code>inspection</Code>
        <Amount>4.00</Amount>
        <IsPublicOfficial>false</IsPublicOfficial>
      </Fee>
    </Fees>
    <Products>
      <DealStructureProduct>
        <Code>vsc</Code>
        <SellingPrice>210.00</SellingPrice>
        <IsInsurance>false</IsInsurance>
      </DealStructureProduct>
      <DealStructureProduct>
        <Code>gap</Code>
        <SellingPrice>220.00</SellingPrice>
        <IsInsurance>true</IsInsurance>
      </DealStructureProduct>
      <DealStructureProduct>
        <Code>ppm</Code>
        <SellingPrice>250.00</SellingPrice>
        <IsInsurance>false</IsInsurance>
      </DealStructureProduct>
      <DealStructureProduct>
        <Code>elg</Code>
        <SellingPrice>260.00</SellingPrice>
        <IsInsurance>false</IsInsurance>
      </DealStructureProduct>
    </Products>
</Input>


The output XML should look like this:

<FieldValuePair name="label1" value="inspection"/>
<FieldValuePair name="value1" value="4.00"/>

<FieldValuePair name="label2" value="vsc"/>
<FieldValuePair name="value2" value="210.00"/>

<FieldValuePair name="label3" value="ppm"/>
<FieldValuePair name="value3" value="250.00"/>

As you can see, the first set of FieldValuePairs came from the /Fees
area of the input, and the 2nd and 3rd set of output nodes came from the
/Products nodes.  The output consists of values taken from Fees where
IsPublicOfficial ne 'true' and values taken from the Product nodes where
IsInsurance ne 'true'.  The output can contain a maximum of 3 pairs, and
the Fees must be exhausted before Products can be used.

I'm thinking I need to create 2 variables, one for the Fees nodes, one
for the Product nodes, and then combine them somehow?  I guess I need to
know how to create the variables (since the output nodes don't look like
the source nodes) and how to join them in the end.  Then, I can ouput
them how I like (max 3 items allowed in output).

Thanks very much for any help that can be provided.

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.