How to regroup xml data

Summary

How to regroup xml data

Content

Hi,

I would like to know if there is a way to transform XML that is received from one source to add a new group. For example, if I have below...

<entries>

    <entry>

        <id>1</id>

        <amount>100</amount>

        <reportId>1</reportId>

    </entry>

    <entry>

        <id>2</id>

        <amount>200</amount>

        <reportId>1</reportId>

    </entry>

    <entry>

        <id>3</id>

        <amount>100</amount>

        <reportId>1</reportId>

    </entry>

    <entry>

        <id>4</id>

        <amount>100</amount>

        <reportId>2</reportId>

    </entry>

</entries>

   

I would like to transform it to add a new group reportGroup so that entries with same reportId are grouped together.

   

<entries>   

    <reportGroup>

        <reportId>1</reportId>

        <entry>

            <id>1</id>