How to use xpath to select the last element into dataset?

bitisony

Hi all,

I want to use xpath function last() to select the last element of one node, but it return empty result.
for example:

<books>
<book name="BIRT"/>
<book name="Test"/>
<book name="JAVA"/>
</books>

my xpath expression is : books/book[last()].

Thanks in advance for your help!

mwilliams

Hi bitisony,

I tried to use the last() function in the row and column mapping with no success. I'm checking into this to see if there is something we're missing. I don't know if using filters or bringing in all the data and just using aggregations will work for you. I'll let you know if I find something else out on the functions.