I am trying to use XPath node to extract the elements from xml file. In XPath node i am trying to get the two elements from xml file and so i have attached two xml queries. I am pasting the xml here:
<book rack="XX" bookTimeStamp="2012-04-18T23:54:26Z" bookFacility="AAAA">
<location rack="first" pos="26" value="47"/>
<book rack="YY" bookTimeStamp="2012-04-18T23:54:33Z" bookFacility="BBBB">
<location rack="second" pos="27" value="47" colno="2"/>
/bookstore/book/bookpathtrackInformation/bookId - to get the book id
/bookstore/book/bookpathtrackInformation/position/location/@colno - to get the column no
I am trying to see the output table which places null value in the first row of column table and '2' value in the second row of column table. But i got the reverse output and i don't know how the XPath node executes it. I am attaching the workflow and xml file here. Please help me to resolve this doubt.