[XMLSCHEMA-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Need to combine duplicate tags in the file

From: Vandna Sharma <sharmav@Excelergy.com>
Date: Wed, 4 Apr 2007 13:42:45 -0400
Message-ID: <66DB9DD3C61F4A429215C094E191288B022B43CD@exchange2k.office.excelergy.com>
To: <xmlschema-dev@w3.org>
Need to combine duplicate tags in the file

I am trying to combine the meter number when there is any duplicate meter number in the file.  Can some please help.

<xsl:variable name="MeterNumber">
							<xsl:value-of select="count(Record[@Name='6000']/Meter_Number)"/>
								 </xsl:variable>
							
				<xsl:choose>
					<xsl:when test="Record[@Name='6000']">	
						<ServiceInformation>
							
							<xsl:when test="$MeterNumber= 1">
							<xsl:for-each select="Record[@Name='6000']/Meter_Number">
								<Service>
									<MeterInformation>
									
											



XML FILE

<Record Name="1000" RecNum="1">
			<Rec_Indicator>1000</Rec_Indicator>
			<Doc_Id>1009271927</Doc_Id>
			<Record Name="2000" RecNum="2">
				<Rec_Indicator>2000</Rec_Indicator>
				<Sender_Trans_Id>C63433</Sender_Trans_Id>
				<Record Name="3000" RecNum="3">
					<Rec_Indicator>3000</Rec_Indicator>
					<Sender_Trans_Id>C63433</Sender_Trans_Id>
					<Id_Code>8S</Id_Code>
					<DUNS_Number>100</DUNS_Number>
					<Name>DELIVERY</Name>
				</Record>
				<Record Name="3000" RecNum="4">
					<Rec_Indicator>3000</Rec_Indicator>
					<Sender_Trans_Id>C63433</Sender_Trans_Id>
					</Record>
				<Record Name="3000" RecNum="5">
					<Rec_Indicator>3000</Rec_Indicator>
					<Sender_Trans_Id>C63433</Sender_Trans_Id>
					<Id_Code>SJ</Id_Code>
					<DUNS_Number>343341</DUNS_Number>
					<Name>ENERGY</Name>
				</Record>
				<Record Name="4000" RecNum="6">
					<Rec_Indicator>4000</Rec_Indicator>
					<Postal_Code>7214618</Postal_Code>
				</Record>
				<Record Name="5000" RecNum="7">
					<Rec_Indicator>5000</Rec_Indicator>
					<Premise_Type_Code>01</Premise_Type_Code>
				</Record>
				<Record Name="6000" RecNum="8">
					<Rec_Indicator>6000</Rec_Indicator>
					<Meter_Number>057676727GE</Meter_Number>
					</Record>
				<Record Name="6000" RecNum="8">
					<Rec_Indicator>6000</Rec_Indicator>
					<Meter_Number>057676727GE</Meter_Number>
					</Record>
				<Record Name="6000" RecNum="8">
					<Rec_Indicator>6000</Rec_Indicator>
					<Meter_Number>123590890HE</Meter_Number>
					</Record>
			</Record>
			<Record Name="9900" RecNum="9">
				<Rec_Indicator>9900</Rec_Indicator>
				<Doc_Id>1009271927</Doc_Id>
				<Records_Generated>5862</Records_Generated>
			</Record>
		</Record>



Thanks
Vandna
Received on Wednesday, 4 April 2007 23:52:36 GMT

Subscribe to the Stylus Scoop newsletter for helpful XML tips and tutorials.
Email
First Name
Last Name
Company

Download Stylus Studio 6 XML Enterprise Edition

Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.