Skip to Content

Receiver File Content Conversion with complex structure

Hi Experts,

The Scenario was Proxy --->PO -->File (FCC).

The structure look like below.

RecordSet ---Occurence : 0-unbounded

Header --- Occurence : 1

Detail1 ----Occurence : 0-unbounded

Deatil2 ----Occurence : 0-unbounded

Detail3 ----Occurence : 0-unbounded

Trailer -----Occurence : 1

I maintained below parameters in Receiver File Content conversion.

RecordSet Structure : Header,Detail1,Detail2,Detail3,Trailer

Header.fieldFixedLengths :10,10,10

Deatil1.fieldFixedLengths :10,10,10

Detail1.endSeparator :'nl'

Deatil2.fieldFixedLengths :10,10,10

Detail2.endSeparator :'nl'

Deatil3.fieldFixedLengths :10,10,10

Detail3.endSeparator :'nl'

Trailer.fieldFixedLengths :10,10,10

Trailer.endSeparator :'nl'

While using above parameters in receiver channel. The output file look like below.

Header

Detail1

Detail1

Detail2

Detail2

Detail3

Detail3

Trailer

But the actual output file should look like below.

Header

Deatil1

Detail2

Detail3

Detail1

Detail2

Detail3

Trailer

Kindly help me on this what parameters should i include in FCC in order to achieve the actual output. I appreciate your help.

Thanks,

Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 01, 2019 at 07:40 AM

    Hi ,

    How does your XML look after mapping? Is it arranged in the same manner as you need or it is not. The parameter will only help you to convert the given XML to flat file. The arrangement of nodes has to be done at the mapping level. Please check this blog , this looks like it suits for your requirement.

    Br,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.