Subject: RE: [xsl] How to map XML to XML according to element values From: "KIENLE, STEVEN C [IT/0200]" <steven.c.kienle@xxxxxxxxxxxxx> Date: Mon, 26 Nov 2001 14:50:35 -0600 |
The following should do what you want. <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" indent="yes"/> <xsl:template match="/"> <xsl:apply-templates /> </xsl:template> <xsl:template match="Company"> <Company> <xsl:apply-templates select="Departments" /> </Company> </xsl:template> <xsl:template match="Departments"> <Departments> <xsl:apply-templates /> </Departments> </xsl:template> <xsl:template match="Department"> <Department> <DeptCode> <xsl:value-of select="DeptCode"/> </DeptCode> <Name> <xsl:value-of select="Name"/> </Name> <xsl:apply-templates select="/Company/Employees/Employee[Dept = current()/DeptCode]" /> </Department> </xsl:template> <xsl:template match="Employee"> <Employee> <EmpNo> <xsl:value-of select="EmpNo"/> </EmpNo> <Name> <xsl:value-of select="Name"/> </Name> </Employee> </xsl:template> </xsl:stylesheet> The key is the select attribute for the xsl:apply-tempates tag under the Department template. This will select all employee nodes whose Dept node matches the current Depatment's DeptCode node. Also, if your files are likely to get large, you may want to look into the xsl:key functionality to speed up that XPath query. Steve -----Original Message----- From: Roy_Lu@xxxxxxxxxxxxxxxx [mailto:Roy_Lu@xxxxxxxxxxxxxxxx] Sent: Monday, November 26, 2001 1:25 PM To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] How to map XML to XML according to element values Hi, I am new to the list and I have searched the archive but couldn't find an answer. I have the following XML, <Company> <Departments> <Department> <DeptCode>D1</DeptCode> <Name>Engineering</Id> </Department> <Department> <DeptCode>D2</DeptCode> <Name>Custom Support</Name> </Department> </Departments> <Employees> <Employee> <EmpNo>E1</EmpNo> <Name>John Smith</Name> <Dept>D1</Dept> </Employee> <Employee> <EmpNo>E2</EmpNo> <Name>Mary Johnson</Name> <Dept>D2</Dept> </Employee> <Employee> <EmpNo>E3</EmpNo> <Name>Tom Baker</Name> <Dept>D1</Dept> </Employee> </Employees> </Company> I would like to transform it into another XML, by matching <DeptCode> in <Department> to <Dept> in <Employee>. The output XML should look like: <Company> <Departments> <Department> <DeptCode>D1</DeptCode> <Name>Engineering</Id> <Employee> <EmpNo>E1</EmpNo> <Name>John Smith</Name> </Employee> <Employee> <EmpNo>E3</EmpNo> <Name>Tom Baker</Name> </Employee> </Department> <Department> <DeptCode>D2</DeptCode> <Name>Custom Support</Name> <Employee> <EmpNo>E2</EmpNo> <Name>Mary Johnson</Name> </Employee> </Department> </Departments> </Company> Can someone give me an advice? Thanks a lot. Roy 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 -> |
---|---|---|
Re: [xsl] How to map XML to XML acc, Jörg Heinicke | Thread | [xsl] Creating a container?, Michael Müller-Hille |
Re: [xsl] How to map XML to XML acc, Jörg Heinicke | Date | Re: [xsl] Comparing a value, Wendell Piez |
Month |