FCC help for File receiver please

[former_member190543]

Hi all,

My issue was not resolved and so posting a fresh question which is much straight forward to ask.

Source is xml. (SOAP)

Target is csv file.

Source structure:

WS_Response                                 ( 1 to  1)

     Result                                         ( 1 to  1)

          Message                                ( 1 to  1)

               Header                              ( 1 to  Unbounded)

                    headerField1

                    headerField2

                    headerField3

                    Item_Line                     ( 0 to  1)

                         Invoices                   ( 0  to Unbounded)

                             invoiceFiled1

                             invoiceFiled2

                             invoiceFiled3

My target cvs file should be: (for example)

headerField1     headerField2     headerField3

invoiceFiled1     invoiceFiled2     invoiceFiled3

invoiceFiled1     invoiceFiled2     invoiceFiled3        (repeat)

headerField1     headerField2     headerField3     (repeat)

invoiceFiled1     invoiceFiled2     invoiceFiled3

invoiceFiled1     invoiceFiled2     invoiceFiled3

But I am getting:

headerField1     headerField2     headerField3     invoiceFiled1     invoiceFiled2     invoiceFiled3

invoiceFiled1     invoiceFiled2     invoiceFiled3        (repeat)

headerField1     headerField2     headerField3     invoiceFiled1     invoiceFiled2     invoiceFiled3

invoiceFiled1     invoiceFiled2     invoiceFiled3

My FCC is as follows:

Recordset Structure: Header,Invoices

Header.endSeparator   : 'nl'

Header.fieldSeparator   : ,

Invoices.endSeparator  : 'nl'

Invoices.fieldSeparator  : ,

I tried using addHeaderLine, filedNames, beginSeparator etc but did not achieve what I am looking for.

Can you guys help?

Many thanks.

[former_member190543 · Accepted solution]

Ok, I got it working myself.

I have used L, as begin separator and removed the "key" field from the structure. I have also inserted an extra node just before the line items and it works as expected. Phew..!