[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
RE: [xsl] Joining two XML-files
Subject: RE: [xsl] Joining two XML-files From: "Michael Kay" <mhkay@xxxxxxxxxxxx> Date: Thu, 18 Oct 2001 17:29:08 +0100 |
Actually, the best solution is to join the tables while they are still in a relational database, rather than doing it with XSLT. Relational databases are usually quite good at joins (they get a lot of practice). If you must do it in XSLT, set up an xsl:key definition to define the join attribute in one file, and use the key() function while processing the other file to bring in the matching record(s). You'll need to use the document() function to reference the second file. Mike Kay > -----Original Message----- > From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx > [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Jorge Bello > Sent: 18 October 2001 14:39 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: [xsl] Joining two XML-files > > > I have 2 XML files obtained from an old legacy system. > (each one is a copy of a relational table). > > Here is an excerpt of every one > file1.xml > <data> > <row att1='foo' att2='morefoo" ... /> > <row att1='foo2' att2='morefoo2" ... /> > ... > </data> > > file2.xml > <data> > <row fld1='foo' fld2='otherfoo" ... /> > <row fld1='foo2' fld2='otherfoo2" ... /> > <row fld1='foo2' fld2='anotherfoo2" ... /> > ... > </data> > > These files are related through the commom value of an attribute. > In the previous example file1.att1 is found in file2.fld1 > I need to produce a third file where get mixed some attributes > of the related "records".For example: > > file3.xml > <row att1='foo' att2='morefoo" fld2='otherfoo" /> > <row att1='foo2' att2='morefoo2" fld2='otherfoo2" /> > <row att1='foo2' att2='morefoo2" fld2='anotherfoo2" /> > ... > </data> > > I'm wondering what is the "best practice" to achieve this. > Any help will be appreciated. > > TIA > Jorge > > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Joining two XML-files, Jorge Bello | Thread | Re: [xsl] Joining two XML-files, Jorge Bello |
RE: [xsl] create multiple documents, Michael Kay | Date | Re: [xsl] xsl output and d-o-e, David Carlisle |
Month |