[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
RE: [xsl] Help needed to transform in data joining
Subject: RE: [xsl] Help needed to transform in data joining From: cknell@xxxxxxxxxx Date: Thu, 02 Nov 2006 10:52:00 -0500 |
<?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:strip-space elements="*" /> <xsl:output method="xml" indent="yes" encoding="UTF-8" /> <xsl:template match="/"> <xsl:apply-templates /> </xsl:template> <xsl:template match="root"> <root> <xsl:apply-templates select="A" /> </root> </xsl:template> <xsl:template match="A"> <A> <xsl:apply-templates /> </A> </xsl:template> <xsl:template match="B"> <B> <xsl:apply-templates /> </B> </xsl:template> <xsl:template match="ADDRESSES"> <ADDRESSES> <xsl:apply-templates /> </ADDRESSES> </xsl:template> <xsl:template match="ADDRESS"> <xsl:variable name="this-id" select="@id" /> <xsl:choose> <xsl:when test="/root/c/addresslists/SBSaddress_[@id = $this-id]"> <ADDRESS> <xsl:copy-of select="/root/c/addresslists/SBSaddress_[@id = $this-id]/*" /> </ADDRESS> </xsl:when> <xsl:otherwise><xsl:copy-of select="." /></xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet> -- Charles Knell cknell@xxxxxxxxxx - email -----Original Message----- From: Kota, Ganesh <gkota@xxxxxxxx> Sent: Thu, 2 Nov 2006 10:19:02 -0500 To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Subject: [xsl] Help needed to transform in data joining Hi, I have this XML file , need to do union of all Address and SBSaddress_ elements based on id attribute join condition in XSL file .Address element has to be overridden in the output if SBSaddress has the data. I appreciate if anybody can help and give some references on this. Thanks, Kota Input XML file: <root> <A> <B> <ADDRESSES> <ADDRESS id='1'><State>CO</State><Address1/><Address2/><City>flroen</City><Countr y>UnitedStates</Country><Province>--Select--</Province><ZipCode>11</ZipC ode><County/></ADDRESS> <ADDRESS id='2'><State>KY</State><Address1>campbellcounty</Address1><Address2/><C ity>fortthomas</City><Country>UnitedStates</Country><Province>--Select-- </Province><ZipCode>41075</ZipCode><County/></ADDRESS> </ADDRESSES> </B> </A> <c> <addresslists> <SBSaddress_ id='1'><State>CO</State><Address1>florence</Address1><Address2/><City>fl roen</City><Country>UnitedStates</Country><Province>--Select--</Province ><ZipCode>11</ZipCode><County/></SBSaddress_> <SBSaddress_ id='2'><State></State><Address1></Address1><Address2>bananacounty</<Addr ess2><City>fortthomas</City><Country>UnitedStates</Country><Province>--S elect--</Province><ZipCode>11</ZipCode><County/></SBSaddress_> </addresslists> </c> </root> ************************************************************************************ The content of this e-mail message and any attachments are confidential and may be legally privileged, intended solely for the addressee. If you are not the intended recipient, be advised that any use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you receive this message in error, please notify the sender immediately by reply email and destroy the message and its attachments. ************************************************************************************
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Help needed to transform in , Kota, Ganesh | Thread | SV: [xsl] Help needed to transform , Per Osnes |
RE: [xsl] How to remove the extra e, cknell | Date | RE: [xsl] Is it possible to create , Michael Kay |
Month |