Group By with a CSV

Summary

I want to group by an element in a csv to create dependecy tree

Content

This is possible with XSLT, but seems quite difficutl to this with OIC, here is another example in stackoverflow
https://stackoverflow.com/questions/2146648/how-to-apply-group-by-on-xslt-elements

 

CSV

item	dependency
ItemA	DependencyA
ItemA	DependencyB
ItemA	DependencyD
ItemB	DependencyA
ItemB	DependencyB
ItemB	DependencyC
ItemC	DependencyC
ItemC	DependencyE

 

The above table is the input CSV

It will output the following XML in oic:

<name>
    <nameset>
        <item>ItemA</item>
        <dependency>DependencyA</dependency>
    </nameset>
    <nameset>
        <item>ItemA</item>
        <dependency>DependencyB</dependency>
    </nameset>
    <nameset>
        <item>ItemA</item>
        <dependency>DependencyD</dependency>
    </nameset>
    <nameset>
        <item>ItemB</item>
        <dependency>DependencyA</dependency>
    </nameset>