[xsl] Merging two XML files

Subject: [xsl] Merging two XML files
From: "Mak, Lucas Wing Kau" <makw@xxxxxxxxxxxxxxxx>
Date: Mon, 16 Nov 2009 14:41:56 -0500
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)

Current Thread