Xpath - Multiple mapping issue

[Gokul Mahalingam]

my xml looks like below where different addresses are mapped using an ID within the same xml.

<test>
<state>
<stateCd>MA</stateCd>
<city>
<addressID>1</addressID>
</city>
<city>
<addressID>2</addressID>
</city>
<state>

<address ID=1>
<line1>Address line 1</line1>
</address>
<address ID =2>
<line1>Address line 2</line1>
</address>
</test>



I need read and display as below

MA Address Line 1
MA Address Line 2



but I am getting:

MA Address Line 1
MA Address Line 1


I am using below xpath to map the addresses.

<xPath>//test/state/city/addressID/text()=../../address/@ID]</xPath>



Any help or suggestion would be really appreciated. Thanks in advance.

Gokul

[g tsuji]

<xPath>//test/state/city/addressID/text()=../../address/@ID]</xPath> 

What is this xpath? and how come it can produce anything or "MA Address Line 1" as said at all?

[Santhosh ayiappan]

Can you try something like this ?

Use the for-each block to iterate the Address and use something like position() to get the correct values