Skip to Content
0
Former Member
Apr 22, 2011 at 05:33 AM

Problem with File Content Conversion (Receiver FIle Adapter)

27 Views

I would like to perform FCC to convert XML file below to flat file. Record is 0..Unbounded

<?xml version="1.0" encoding="UTF-8"?>

http://sap.com/xi/TT">

<RecordSet>

<Record>

<field1>3</field1>

<field2></field1>

<field3></field1>

<field4></field1>

<field5></field1>

<field6></field1>

</Record>

<Record>

<field1>1</field1>

<field2>C</field1>

<field3>D</field1>

<field4>E</field1>

<field5>F</field1>

<field6>G</field1>

</Record>

<Record>

<field1>2</field1>

<field2>C</field1>

<field3>D</field1>

<field4>E</field1>

<field5></field1>

<field6>G</field1>

</Record>

<Record>

<field1>3</field1>

<field2>C</field1>

<field3>D</field1>

<field4></field1>

<field5></field1>

<field6>G</field1>

</Record>

</RecordSet>

Here is my Content Conversion Parameters,

Recordset Structure: Record

Record.fieldSeparator= ,

Record.endSeparator='nl'

I expect to get output below,

3

1,C,D,E,F,G

2,C,D,E,,G

3,C,D,,,G

But I keep getting output below,

3,1,2,3

Is something wrong with my FCC parameters?