[xsl] Suppressing multiple outcome

["Andreas Putscher" <AndreasPutscher@xxxxxx>]

Hello,

I am facing the following problem


I have an invoice:

<?xml version="1.0"?>
<INVOICE>
<ORDERHEADER>
</ORDERHEADER>
<ORDERPOSITIONS>
<ITEM>
	<MATNR>123</MATNR>
	<DETAIL>
		<PARVW>WE</PARVW> 
		<STREET>oxford street</STREET> 
	</DETAIL>
	<DETAIL>
		<PARVW>Z5</PARVW> 
		<STREET>another street</STREET> 
	</DETAIL>
</ITEM>
<ITEM>
	<MATNR>456</MATNR>
	<DETAIL>
		<PARVW>WE</PARVW> 
		<STREET>oxford street</STREET> 
	</DETAIL>
	<DETAIL>
		<PARVW>Z5</PARVW> 
		<STREET>another street</STREET> 
	</DETAIL>
</ITEM>
</ORDERPOSITIONS>
</INVOICE>


-> The invoice has 2 positions <ITEM>. Each position has a <DETAIL>-Tag, which has the same contents FOR ALL items.
What i would like to do is to get the content of Tag <STREET>, if the <PARVW>-Tag contains "WE" -> in this case this ist the value "oxford street".

in the destinaion xml, "oxford street" sould be in the header segment.
The destination XML should look like:

<?xml version="1.0"?>
<INVOICE>
<ORDERHEADER>
<STREET>oxford street</STREET>
</ORDERHEADER>
<ORDERPOSITIONS>
<ITEM>
	<MATNR>123</MATNR>
</ITEM>
<ITEM>
	<MATNR>456</MATNR>
</ITEM>
</ORDERPOSITIONS>
</INVOICE>


I habe generated the following code with Altova MapForce:

<ORDERHEADER>
<xsl:for-each select="ITEM/DETAIL">
		<xsl:variable name="myVar" select="."/>
		<xsl:for-each select="$myVar/PARVW">
			<xsl:variable name="myVar3" select="$myVar/PARVW = 'WE'"/>
			<xsl:if test="string($myVar3)='true'">
				<STREET>
					<xsl:value-of select="$myVar/STREET"/>
				</STREET>
			</xsl:if>				
		</xsl:for-each>
</xsl:for-each>		
</ORDERHEADER>

Unfortunately the outcome is the following (I get the Tag <STREET> twice, whereas I would like to get it only ONCE):
<ORDERHEADER>
	<STREET>oxford street</STREET>
	<STREET>oxford street</STREET>
</ORDERHEADER>

Does anybody know, what I can do so that the destination.xml contains ONLY ONE <STREET>-tag?
I hope I did make my problem clear.

Thanks in advance,
Andreas

-- 
"Ein Herz f|r Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de
Unser Dankeschvn: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht!