Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] flat XML to normal XML
 I wish to transform an xml which has level information in each item (Table) to xml which has hierarchy as stated in those item's element. <DataSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Table>
<Level>1</Level>
<Description>Cars</Description>
</Table>
<Table>
<Level>2</Level>
<Description>BMW</Description>
</Table>
<Table>
<Level>3</Level>
<Description>316</Description>
</Table>
<Table>
<Level>3</Level>
<Description>Z4</Description>
</Table>
<Table>
<Level>2</Level>
<Description>Citroen</Description>
</Table>
<Table>
<Level>3</Level>
<Description>C2</Description>
</Table>
<Table>
<Level>3</Level>
<Description>C4 coupe</Description>
</Table>
<Table>
<Level>2</Level>
<Description>Alfa Romeo</Description>
</Table>
<Table>
<Level>3</Level>
<Description>156</Description>
</Table>
<Table>
<Level>1</Level>
<Description>Motorcycles</Description>
</Table>
...
...
</DataSet>Target xml should look something like this: <NewDataSet> <Transport name="Cars"> <Brand name="BMW"> <Model>316</Model> <Model>Z4</Model> </Brand> <Brand name="Citroen"> <Model>C2</Model> <Model>C4 coupe</Model> </Brand> <Brand name="Alfa Romeo"> <Model>156</Model> </Brand> </Transport> <Transport name="Motorcycle"> ... </Transport> </NewDataSet> So, based on the Level element in the source xml for each Table entry, an appropriate subtree must be constructed and inserted in target xml. Levels are ordered following this pattern: 1,2,3,3,...,3,2,3,...,3,...,1,2,3,3,...,2,3,...,3 Busting my head over this for two days now, help appreciated. If only I could find the guy who created this "flat" xml...$%##@@! --Bob 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
