Hi,
Though I have been working sometime with XSLT, I am having trouble with this
transformation. Anyone know how to do this? The XML source is from a
database and is really really huge in size, so performance of the
transformation is very critical...
<Root>
<Community>
<City>City1</City>
<A>
<B>
<Name>Name1</Name>
<Info>
<Detail no="100">Red</Detail>
</Info>
</B>
<B>
<Name>Name2</Name>
<Info>
<Detail no="200">Blue</Detail>
</Info>
</B>
<B>
<Name>Name3</Name>
<Info>
<Detail no="300">Green</Detail>
</Info>
</B>
</A>
</Community>
<Community>
<City>City2</City>
<A>
<B>
<Name>Name4</Name>
<Info>
<Detail no="100">Red</Detail>
</Info>
</B>
<B>
<Name>Name5</Name>
<Info>
<Detail no="200">Blue</Detail>
</Info>
</B>
<B>
<Name>Name6</Name>
<Info>
<Detail no="400">Yellow</Detail>
</Info>
</B>
</A>
</Community>
</Root>
This is the result I need to produce:
100, Red
City1
Name1
City2
Name4
200, Blue
City1
Name2
City2
Name5
300, Green
City1
Name3
400, Yellow
City2
Name6