Subject: [xsl] Retrieving data from two XMLs and creating another XML using XSLT|
From: Manasi Kulkarni <Manasi.Kulkarni@xxxxxxxxxxxxxxxx>
Date: Wed, 15 Feb 2006 13:41:53 -0500
I want to read data from two XML files with completely different structure and build third XML using XSLT. The input XML files are of the form: Input File 1: <Data> <Section> <Specimen Name="John Smith"> <Test Name="Test1"> <Result> <TextResult Value="123"/> <Result> </Test> </Section> </Data> Input File 2: <Root> <Form Name="Form1"> <Section Name="Sect1"> <Set Name="Set1"> <Item Name="Item1"/> </Set> </Section> </Form> </Root> Output File: <Info> <Person Name="John Smith"> <Data Tag="Sect1.Set1.Item1" Value="123"/> </Person> </Info> The output XML contains some value from first XML and some from second XML. My mail problem is creating 'Tag' attribute for output XML which is concatenated string of values from second XML. I tried using xsl:variable / param, however it gives me an error when I use concat function with variables. Can this be done using XSL? Or should I write custom converter using Java / C#? Any help would be appreciated. Thanks, Manasi This message contains privileged and confidential information intended only for the use of the addressee(s) named above. If you are not the intended recipient of this message, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by return electronic mail and delete the original message without retaining a copy.