FCC parameter to create multiple lines

[Former Member]

Hi All

I have IDOC to FILE scenario.It is working fine end to end and can able to create Flat file.

It is not a fixed length file.I am using FCC to convert XML to flatfile.

Output XML structure:

Header                   0 to unbounded

     Record              1 to 1

          field1            0 to 1  

          field2            0 to 1

     Record2               0 to unbounded

          field3               0 to unbounded

Present Output file:

[14]2142[20]MMA8728502[21]M1A[23]2016-07-27[24]0[25]1[2C]0[2R]0[26]3.999[27]0.087

[02]0I[I1]00278703851006883509[I2][99][02]0I[I1]00278703851006883516[I2][99][02]0I[I1]00278703851006883523[I2][99]

I am fine with Record(first line)

If we see in Record2(second line) field3 repeated thrice.

Expected output file:

[14]2142[20]MMA8728502[21]M1A[23]2016-07-27[24]0[25]1[2C]0[2R]0[26]3.999[27]0.087

[02]0I[I1]00278703851006883509[I2][99]

[02]0I[I1]00278703851006883516[I2][99]

[02]0I[I1]00278703851006883523[I2][99]

Please find the screen shots of FCC and output mapping and kindly advise:

I have tried giving .endSeparator and .fieldSeparator as 'nl' still its not working

[manoj_khavatkopp · Accepted solution]

Anitha,

The FCC is wrong  , Record and Record2 are child nodes of header , But according to your FCC the Header,Record,Record2 are siblings.

So this becomes deeply nested xml which cant be handled in FCC.

So you can remove the header and keep only the Record and Record2 This can be done using NodeDeception .

use the code from this Link :

Br,

Manoj

[Former Member · Accepted solution]

Hi Manoj

Thanks for your reply!!

But I achieved this with normal FCC .

The below changes I have made in FCC parameters and got the desired output file.Hence closing the thread.

RecordSet structure: Header,Record,Record2

Header.fieldSeparator    '0'

Record.fieldSeparator    '0'

Record.endSeparator    \r\n

Record2.fieldSeparator    \r\n

Record2.endSeparator    \r\n

Regards

Anitha