[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Merging two XML files
1) Process fileA using the identity transform 2) In the <record> template, key into fileB using the title, where the key matches "record" and uses "title" 3) Copy the name and url elements, or *[not(self::title)] cheers andrew 2009/11/16 Mak, Lucas Wing Kau <makw@xxxxxxxxxxxxxxxx>: > I want to merge two XML files (i.e. fileA & fileB below) by matching the values in their <title> elements and grabbing everything from fileA, but only the <url> element from fileB. > > fileA > <collection> > <record> > <title>abc</title> > <name>peter</name> > </record> > <record> > <title>def</title> > <name>jack</name> > </record> > <record> > <title>ghi</title> > <name>john</name> > </record> > </collection> > > fileB > <collection> > <record> > <title>abc</title> > <date>11/23/2008</date> > <url>http://no.com</url> > </record> > <record> > <title>ghi</title> > <date>12/12/2007</date> > <url>http://hello.com</url> > </record> > <record> > <title>cmyk</title> > <date>10/12/2006</date> > <url>http://hi.com</url> > </record> > </collection> > > Output XML > <collection> > <record> > <title>abc</title> > <name>peter</name> > <url>http://no.com</url> > </record> > <record> > <title>ghi</title> > <name>john</name> > <url>http://hello.com</url> > </record> > </collection> > > How I can do it? I am using XSLT 1.0 since I am more familiar with 1.0 (though my processor also support 2.0) > > Thanks in advance. > > Wing (makw@xxxxxxx) > > -- Andrew Welch http://andrewjwelch.com Kernow: http://kernowforsaxon.sf.net/
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|