We have a "flat" xml:

<CLO>Customer</CLO>
<DIN>Date</DIN>
<ORD>Product234</ORD>
<QTY>23</QTY>
<ORD>Product676</ORD>
<QTY>25</QTY>

we need to translate this to a hierarchical view, something like:

<Header>
   <CLO>Customer</CLO>
   <DIN>Date</DIN>
   <Details>
      <Detail>
         <ORD>Product234</ORD>
         <QTY>23</QTY>
      </Detail>
      <Detail>
         <ORD>Product676</ORD>
         <QTY>25</QTY>
      </Detail>
   </Details>
</Header>

So we iterate the nodes and for each <CLO> node we hit we create a <Header> node in the resultant XML, and for each <ORD> node underneath that <CLO> we output a <Detail> for that <Header>.

One problem is we do not know how many <CLO> nodes there will be or how many <ORD> nodes refer to that <CLO> (the subsequent <ORD> nodes always apply to the previous <CLO>).

The big issue is that we need to open a <Header> node if we find a <CLO> but we wont be closing that header node until we have iterated the nodes a few more times to find the next <CLO> this causes the XSL document to not be well formed and so does not work.

Can anyone give us any tips on how to do this?

Thanks for your time

Yo!

Why don't you post your XSL just see where you are now. This forum is cool but don't expect someone to work for you for free...

Let's see what's wrong with your code, and then you might get help.

Hasta pronto!
Rushman

Dijkstra's law on Programming and Inertia:

If you don't know what your program is supposed to do, don't try to write it.

Sorry Rushman, I found your reply both unhelpful and antagonistic. I am not asking anyone to work for me for free. I was was asking for tips not code.

I cannot think of a way to do what I am looking to do, in fact I actually don't think it is possible, with that in mind I have no code to show.

I am not looking for a "what is wrong with this code" answer, but rather a few helpful hints or tips on how to overcome this specific problem.

Try a search for "XSLT positional grouping".

In 2.0 use <xsl:for-each-group group-starting-with="CLO"/>.

In 1.0 it's rather more difficult.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks very much mhkay, thats exactly what I was looking for.