• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Xpath - Multiple mapping issue

 
Gokul Mahalingam
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 656
3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

What is this xpath? and how come it can produce anything or "MA Address Line 1" as said at all?
 
Santhosh ayiappan
Ranch Hand
Posts: 80
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic