I must map a flat file that has the following format to a XML structure. I have made a template (included in attachment) and the file is loading OK in the record so I have all my data in the pipeline. The file (an invoice) has 1 field per line instead of having many fields on 1 line. So for detail records, it goes like this :
310 Product description
310 Prod desc 2
My goal is to load this to an XML structure like this :
<description>Prod desc 2</description>
I’ve tried many LOOP, MAP combined with appendToRecordList to a temp records and/or directly to my XML structure but was not able to produce an output that was making sense. The best I could do was having the correct line detail structure but with the same data in each detail line
I’m sure somebody in here has done something similar ?
Thanks for your help !
flat file invoice template
AlphaInvoiceTemplate.xml (14.6 k)