Need to combine duplicate tags in the file

• From: Vandna Sharma <sharmav@Excelergy.com>
• Date: Wed, 4 Apr 2007 13:42:45 -0400
• To: <xmlschema-dev@w3.org>
• Message-ID: <66DB9DD3C61F4A429215C094E191288B022B43CD@exchange2k.office.excelergy.com>

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 UTC