How to concat nested list in the Table with XML Datasource

0

Hi all,

<report>
<table>
    <persons>
        <person>
            <id>111</id>
            <name>John</name>
            <addresses>
                <address>Johan's Street 1</address>
                <address>Johan's Street 2</address>
                <address>Johan's Street 3</address>
            </addresses>
        </person>
        <person>
            <id>222</id>
            <name>Marko</name>
            <addresses>
                <address>Marko's Street 1</address>
                <address>Marko's Street 2</address>
            </addresses>
        </person>
        <person>
            <id>333</id>
            <name>Tito</name>
            <addresses>
                <address>Tito's Street 1</address>
                <address>Tito's Street 2</address>
                <address>Tito's Street 3</address>
                <address>Tito's Street 4</address>
            </addresses>
        </person>
    </persons>
</table>
</report>

I trying to generate a report from above xml. I need to concat list of address element in table

Expected Result:

NAME ADDRESSES
John Johan's Street 1 , Johan's Street 2 , Johan's Street 3
Marko Marko's Street 1 , Marko's Street 2
Tito Tito's Street 1 , Tito's Street 2 , Tito's Street 3 , Tito's Street 4

botyro's picture
2
Joined: May 22 2017 - 12:53am
Last seen: 2 years 3 months ago

0 Answers:

No answers yet
Feedback
randomness