[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: How to map XML to XML according to element values
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: 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|