Skip to Content
0
Nov 01, 2012 at 05:27 PM

Conversion

34 Views

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>