Hi Group,
I am having one requirement to convert deep structure in to flat structure can any body help with the below example:
Source file structure looks like below:
HDR 1
VEN 0..1
GROUP 0..Unbound
DA 0..Unbound
NOC 0..Unbound
Source
-------
<HDR>
<Date>20090419</Date>
</HDR>
<VEN>
<VId>IND</VId>
<Name>DEL</SupplierName>
<GROUP>
<GroupId>P</GSPGroupId>
<GroupName>Western</GSPGroupName>
<DA>
<DId>EEE</DId>
<DName>Electricity</DName>
<NOC>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value1>0.000</Value1>
<Value2>0</Value2>
<Value3>58.137</Value3>
<Value4>1</Value4>
<Value5>0.000</Value5>
</NOC>
<NOC>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value1>0.001</Value1>
<Value2>1</Value2>
<Value3>59.137</Value3>
<Value4>2</Value4>
<Value5>1.000</Value5>
</NOC>
</DA>
</GROUP>
</VEN>
Target
------
<MT_TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value>0.000</Value>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value>0</Value>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value1>58.137</Value1>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value1>1</Value1>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>1</Id>
<SId>0188</SId>
<LId>3</LId>
<DisId>EELC</DisId>
<PTR>01191</PTR>
<Value1>0.000</Value1>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value>0.001</Value>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value>1</Value>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value1>59.137</Value1>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value1>2</Value1>
</TRG>
<TRG>
<VId>IND</VId>
<GroupId>P</GSPGroupId>
<DId>EEE</DId>
<Id>2</Id>
<SId>0189</SId>
<LId>4</LId>
<DisId>EELC1</DisId>
<PTR>01192</PTR>
<Value1>1.00</Value1>
</TRG>
</MT_TRG>