I have a situation that is well over my head. I need to take a flat layout and transform it into a hierarchical layout. (See attachments)
I actually have a prototype XSLT that uses named templates and having one template call the other to create somewhat of the hierarchy. Currently, the structures are repeating. I need to know how not to have them repeat. I also can't get my head around how to find and extract the complete content at the correct place.
I would have posted my XSLT, but, I may be headed in completely the wrong direction. What I'd like is to get proper guidance on how to do it.
I suspect I'll have to learn about muenchian grouping, but still have no idea how to proceed.
I'm also limited to XSLT 1.0.
SampleCustomerSalesHierarchical.xml
SampleCustomerSalesFlat.xml