I have a simple XML structure as follows:
<A>
<row><item>1</item></row>
<row><item>1</item></row>
<row><item>2</item></row>
</A>
I need to consolidate all the <row> records into <group> records
whenever <item> changes, for example:
<A>
<group>
<row><item>1</item></row>
<row><item>1</item></row>
</group>
<group>
<row><item>2</item></row>
</group>
</A>
I've tried the SplitByValue(), collapseContents() removeContents() node
functions but cannot come up with a workable solution. Can anyone provide a suggestion?