xsl-list
[Top] [All Lists]

Re: [xsl] Mapping from two sources

2010-10-02 05:59:58
Hi, 

does xsl:for-each-group acts like inner join?

Thank you for the response. 

--- On Fri, 10/1/10, Michael Kay <mike(_at_)saxonica(_dot_)com> wrote:

From: Michael Kay <mike(_at_)saxonica(_dot_)com>
Subject: Re: [xsl] Mapping from two sources
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Date: Friday, October 1, 2010, 5:13 PM
  On 01/10/2010 8:14 PM,
sudheshna iyer wrote:

Grouping handles this well:

<xsl:for-each-group select="$doc1//OrderLine,
$doc2//POOrderline" 
group-by="OLN">
<Oline>
<OLN><xsl:value-of
select="current-grouping-key()"></OLN>
<xsl:copy-of select="current-group()/(FName, ID)"/>
</Oline>
</xsl:for-each-group>

Michael Kay
Saxonica

I need to have two sources:

input1 and input2.

input1:
<?xml version="1.0" encoding="ISO-8859-1"?>
<Order>
    <OrderLine>
       
    <OLN>1</OLN>
       
    <Fname>aa</Fname>
    </OrderLine>
    <OrderLine>
       
    <OLN>2</OLN>
       
    <Fname>bb</Fname>
   
</OrderLine>    
</Order>


input2:
<?xml version="1.0" encoding="ISO-8859-1"?>
<POOrder>
    <POOrderLine>
       
    <OLN>1</OLN>
       
    <ID>123</ID>
       
    <LName>aa</LName>
    </POOrderLine>
    <POOrderLine>
       
    <OLN>2</OLN>
       
    <ID>324</ID>
       
    <LName>bb</LName>
   
</POOrderLine>    
</POOrder>

I need the output from both sources combined. Please
note that first two elements are coming from input1 and
thrid element is from input2. What is the
optimal way of doing this?

<?xml version="1.0" encoding="ISO-8859-1"?>
<OrderResponse>
    <Oline>
       
<OLN>1</OLN>
       
<Fname>aa</Fname>
       
<ID>123</ID>
    </Oline>
    <Oline>
       
<OLN>2</OLN>
       
<Fname>bb</Fname>
       
<ID>324</ID>
    </Oline>
</OrderResponse>





--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or 
e-mail:<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--




--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--




      

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>