I grabbed a copy of this today and been looking through the forum trying to sort this myself, but I've gotten a bit stuck. What I'm trying to do is map a complex CSV file that has transactional information in it to XML. I can create a flat structure, but this will be difficult to work with later and thought that this may be something that is easily dealt with using something that I've not seen yet.
The data looks like the following
001|start of customer|custInfo1|custInfo2|
002|customer detail|detail1|...|
003|start of invoice|invoice1|...|
004|invoice detail|invoiceDetail1|...|
003|start of invoice|invoice1|...|
004|invoice detail|invoiceDetail1|...|
001|start of customer|custInfo1|custInfo2|
The problem is I don't see a way to define child objects other than by using regions, which looks like the wrong way to go.
Do I map each of the record types (001,002 etc.) with the node/pattern, let the converter do it's thing and spit out a flat version of the CSV in XML then write a very complex transformation later to assign the parent/child relationships, or is there an easier way to go?