Hello Jedox community,
For simplicity purposes I will use the example of books.

I have an xml with a bookstore and list of several books.
I can extract the value of one specific book like this (by default->>> /bookstore/book[1] or this /bookstore/book[last()]

However, what I can not do is to query the xml to select multiple books with for example --> /bookstore/book[price>35.00]

as it allows me to select only one book and returns a data preview message "Several nodes retrieved from xpath book[price>35.00] in some directory nodes, only the first one will be read."


Please advise -- as there is very limited info in knowledge-base about xml file extracts, besides the link to w3schools.com/.

By Andrej Matisic –


Dear Rolands,
you can try following as show in the screenshot.
Using "/bookstore/book[text()][price>5]" in my xPathLoopSource solved it.
I hope it helps.
BR
Andrej