'Counting true/false occurences on XML

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
javaxmltalend


Solution 1:[1]

Finnaly I succeed with: tFileInputXml -> tXMLMap -> tAggregateRow -> tLogRow

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Frédéric Pouget

Related Questions