cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver File Content Conversion with complex structure

sapviswanadh
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

manoj_khavatkopp
Active Contributor
0 Kudos

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