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"?>
<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?