Hi,

I need to transform below input XML to output XML. Can you please provide any ideas for this


Input XML :

<?xml version="1.0" encoding="UTF-8" ?>
<GenericCollection ParamValue="ParamValue1" xmlns="http://www.example.org">
<Generic>
<store>Store1</store>
<metricName>Metric1</metricName>
<metricValue>1</metricValue>
</Generic>
<Generic>
<store>Store1</store>
<metricName>Metric2</metricName>
<metricValue>1</metricValue>
</Generic>
<Generic>
<store>Store2</store>
<metricName>Metric1</metricName>
<metricValue>1</metricValue>
</Generic>
<Generic>
<store>Store2</store>
<metricName>Metric1</metricName>
<metricValue>2</metricValue>
</Generic>
<Generic>
<store>Store2</store>
<metricName>Metric2</metricName>
<metricValue>1</metricValue>
</Generic>
<Generic>
<store>Store3</store>
<metricName>Metric1</metricName>
<metricValue>1</metricValue>
</Generic>
<Generic>
<store>Store3</store>
<metricName>Metric1</metricName>
<metricValue>2</metricValue>
</Generic>
</GenericCollection>


Output XML :

<?xml version = '1.0' encoding = 'UTF-8'?>
<ns4:EnterpriseDocument>
<ns4:DataSet>
<ns4:Dimension ref_name="bu_code" value="Store1">
<ns4:Metric ref_name="Metric1">
<ns4:Data value="1"/>
</ns4:Metric>
<ns4:Metric ref_name="Metric2">
<ns4:Data value="1"/>
</ns4:Metric>
</ns4:Dimension>
<ns4:Dimension ref_name="bu_code" value="Store2">
<ns4:Metric ref_name="Metric1">
<ns4:Data value="1"/>
<ns4:Data value="2"/>
</ns4:Metric>
<ns4:Metric ref_name="Metric2">
<ns4:Data value="1"/>
</ns4:Metric>
</ns4:Dimension>
<ns4:Dimension ref_name="bu_code" value="Store3">
<ns4:Metric ref_name="Metric1">
<ns4:Data value="1"/>
<ns4:Data value="2"/>
</ns4:Metric>
</ns4:Dimension>
</ns4:DataSet>
</ns4:EnterpriseDocument>


Thanks,
Ramesh

You should use XSLT.