I need to count specifics occurences on XML ("true" or "false") and get the results in a table
I try using a tXMLMap but so far without success.
Any idea where I can lookinf for?
My XML:
<?xml version="1.0" encoding="UTF-8"?>
<customers>
<customer id="1">
<customerStatus vip="false" gold="false"/>
</customer>
<customer id="2">
<customerStatus vip="true" gold="false"/>
</customer>
<customer id="3">
<customerStatus vip="true" gold="true"/>
</customer>
</customers>
Wishes result:
| vip | gold |
|---|---|
| 2 | 1 |