I am trying to create a map to convert a file consisting of just order lines into one with a order, order line hierarchy. e.g.
Order1, Line1
Order1, Line2
Order2, Line3
Order3, Line4
into…
<Order>
<OrderName>Order1</OrderName>
<OrderLine>Line1</OrderLine>
<OrderLine>Line2</OrderLine>
</Order>
<Order>
<OrderName>Order2</OrderName>
<OrderLine>Line3</OrderLine>
</Order>
<Order>
<OrderName>Order3</OrderName>
<OrderLine>Line4</OrderLine>
</Order>
I thought that this should be a simple task but…
- If I just map one record format to the other then I get an <Order> node for each line on the input file.
- However if I use a Looping functiod with a logical operator to suppress the creation of the <Order> node for the second line of the input file, it also suppress the creation of the <OrderLine> node.
Can anyone give me some pointers to what I should be doing?
Many thanks,
Neil