TopXML XSLT library : Cross Reference Lookup in XSLT using XML file as Xref table

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

XSLT
XSLT
XSLT Contents
Recursion reminds me of Recursion (9 XSLT Recursion examples)
XSLT Sort - output entire xml file with new sort order
Variable Variables
Cross Reference Lookup in XSLT using embedded XML
XTrans 1.0
XML Explorer 2.5
Create an N-Column Table from XML node-set
XSLT Select Option Example
XSLT Date filtering, sorting, comparing, and evaluating
XSLT Template for HTML INPUT Tag
XSLT Template for HTML IMG Tag
XSLT Search and Replace Template
Word wrap and text replace templates for XSLT
nxslt 1.3
Visual XPath
xframe - xsddoc
-xsl-fo-->-pdf--making-an-e-book/documentation.aspx>BIBLE PDF from (xml & xsl)-> xsl-fo -> pdf ; Making an E-book/documentation
Sum(round(.))
DISTINCT list of attributes using XPATH only
How to add a XSL information to the XML file with the XmlTextWriter?

<< XQuery .NET and XML >>

By	John Workman
First Posted	05/24/2003
Times viewed	964

Cross Reference Lookup in XSLT using XML file as Xref table

This post contains attachments
v20030524111113.zip

Summary This snippet shows you how to use an xml file as a xref table in the middle of transforming a separate xml document.

Have you every needed to use a cross reference table when transforming an xml document? This snippet shows you how. The example shows a payroll file that needs to have the payroll id replaced with the employee id. A JScript is included. If you double click on the JScript it will transform the document and create and output.xml file. It loads the xref document into a variable. Then it loops through the source document re-writing the xml file while replacing the payrollID with the employeeID. One thing to be careful of is make sure that you load the document into a variable outside of the loop and then search the variable instead of re-loading the file each time.

Additional information
<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:msxsl = 'urn:schemas-microsoft-com:xslt' xsl:space="preserve"> <xsl:output method='xml' omit-xml-declaration='yes' encoding='ASCII'/> <xsl:template match="/"> <xsl:variable name='xrefdoc' select="document('xref.xml')"/> <xsl:element name='doc'> <xsl:element name='payroll'> <xsl:for-each select='doc/payroll/record'> <xsl:element name='record'> <xsl:variable name='origpayid' select='@payrollID'/> <xsl:attribute name='payrollID'>  <xsl:value-of select="$xrefdoc//doc/xref[@payrollID=$origpayid~/@employeeID"/> </xsl:attribute> <xsl:attribute name='hours'> <xsl:value-of select='@hours'/> </xsl:attribute> <xsl:attribute name='rate'> <xsl:value-of select='@rate'/> </xsl:attribute> </xsl:element> </xsl:for-each> </xsl:element> </xsl:element> </xsl:template> </xsl:stylesheet>

Further additional information
<doc> <payroll> <record payrollID="123456" hours="40" rate="12.00" /> <record payrollID="223456" hours="40" rate="12.00" /> <record payrollID="323456" hours="40" rate="12.00" /> <record payrollID="423456" hours="40" rate="12.00" /> <record payrollID="523456" hours="40" rate="12.00" /> </payroll> </doc> <doc> <xref payrollID="123456" employeeID="654321" /> <xref payrollID="223456" employeeID="654322" /> <xref payrollID="323456" employeeID="654323" /> <xref payrollID="423456" employeeID="654324" /> <xref payrollID="523456" employeeID="654325" /> </doc> <doc> <payroll> <record payrollID="654321" hours="40" rate="12.00" /> <record payrollID="654322" hours="40" rate="12.00" /> <record payrollID="654323" hours="40" rate="12.00" /> <record payrollID="654324" hours="40" rate="12.00" /> <record payrollID="654325" hours="40" rate="12.00" /> </payroll> </doc>

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :

<< XQuery .NET and XML >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Software Specialist, Linux - Finland Linux Core Technical Project Manager/ Sc Graphics designer at Tanzania. Experienc Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc View all Jobs (Add yours) View all CV (Add yours)



	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML