RE: [xsl] Retrieving data from two XMLs and creating another XML using XSLT

Subject: RE: [xsl] Retrieving data from two XMLs and creating another XML using XSLT
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Wed, 15 Feb 2006 21:50:51 -0000
Yes, this problem can be readily solved in XSLT. If you show us your code,
we can tell you where you went wrong.

Michael Kay
http://www.saxonica.com/ 

> -----Original Message-----
> From: Manasi Kulkarni [mailto:Manasi.Kulkarni@xxxxxxxxxxxxxxxx] 
> Sent: 15 February 2006 18:42
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: [xsl] Retrieving data from two XMLs and creating 
> another XML using XSLT
> 
> 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. 

Current Thread