Unable to retrieve attribute values from an XML file

I have an XML file with the following structure:

<glucose_level>


</glucose_level>

I would like to retrieve the dates value 18-01-2022 00:01:00 and the measurement values (179, 183). My workflow is listed below
afbeelding
The settings of the second XPath node are:
afbeelding
Whatever settings I aplly the result is the same: the values “29-10-2021 00:01:00" and 239 are not extracted.
When I right click the XML-Cell Preview the test “selected XML element is not a tag nor an attribute” appears next in the Selected path field/
afbeelding

Who can give me the solution? Any help is appreciated

Hi @reedere

You’re looking for /event/@ts and /event/@value.

Within the Xpath node, click on the attributes ts and value to get the corresponding queries.

3 Likes

Thanks a lot for your answer. I can retrieve the values without problem

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.