Hi All,
I have the below nested XML structure which I want to convert into a flat file(fixed length).
<ns1:MT_MaterialSales_File>(1:1)
<HEADER>..fields..</HEADER> (1:1)
<INVOICE_GROUPS> (1:unbounded)
<INVOICE_HEADER>..fields..</INVOICE_HEADER> (1:1)
<INVOICE_DETAILS>..fields..</INVOICE_DETAILS> (1:unbounded)
</INVOICE_GROUPS>
<FOOTER>..fields..</FOOTER> (1:1)
</ns1:MT_MaterialSales_File>
The desired output will be like this:
-
HEADER.......<fields of fixed length>
INVOICE_HEADER..INVOICE_DETAILS..
FOOTER...<fields of fixed length>
-
i.e all INVOICE_GROUPS are in a single line one after the other.
Can someone help me what parameters to use to get this done using FCC?
Thanks a lot
Rajeev