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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 01 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 comment
    10|10000 characters needed characters exceeded