Creating optimized XML from table

Hello!

I’m trying to create optimized XML files from an excel table. My data source looks like this:

Column1 - Values: A ; A ; A ; A; B; B.

Column2 - Values: A1 ; A1 ; A2 ; A2; B1; B2.

Column3 - Values: A11 ; A12 ; A21 ; A22; B11; B21.

I would like to obtain an XML looking like this:

<root>
<group Column1="A">
<subgroup Column2="A1">
<item>
<Column3>A11</Column3>
</item>
<item>
<Column3>A12</Column3>
</item>
</subgroup>
<subgroup Column2="A2">
<item>
<Column3>A21</Column3>
</item>
<item>
<Column3>A22</Column3>
</item>
</subgroup>
</group>
<group Column1="B">
<subgroup Column2="B1">
<item>
<Column3>B11</Column3>
</item>
</subgroup>
<subgroup Column2="B2">
<item>
<Column3>B21</Column3>
</item>
</subgroup>
</group>
</root>

So far, I’ve done a Column to XML on Column1, Column2 and Column3 but that doesn’t really do the trick because it doesn’t optimise it and, after applying the XML Row combiner I end up with something like:

<name Column1="A" Column2="A1" Column3="A11"></name>
<name Column1="A" Column2="A1" Column3="A12"></name>

…

I’ve checked the XML Creator component from the Hub but I’m not too convinced either.

Any ideas on how to tackle this situation?

Many thanks for your help in advance!

J.