I have a csv file containing rows with customer orders which I want to map to an XML invoice object which generates an invoice containing all the customer orders.
The incoming data looks like this:
The target schema is an XML with the following structure:
My desired outcome would be to loop through the incoming rows where customer id is e.g. 4, and write the two orders as InvoiceRow elements, within the “invoices” object, producing two documents as output looking like this:
My current pipeline looks like this and just maps the four flat incoming documents to four output documetns:
Does anyone have any tips on how to acchieve this?