I'm trying to work with the "Get data from XML" step, specifically with the Xpaths to select data:
My data is roughly in the form:
<activity default-currency="EUR"> <value currency="USD">10000</value> <value>10000</value> </activity>
I am doing a loop over activity/value.
In Xpath, I can use the expression
to get either the currency attribute if it exists, or the default-currency attribute of the parent, otherwise. (And then use the string value of it.)
It seems Kettle is able to do some types of Xpath expressions, but not sequences like this?
I can't find which version of Xpath is supported, it seems like Xpath 1.0? Is there a way to upgrade it to Xpath 2.0?