Help needed in FILE CC
Hi All,
I am trying to convert XML to CSV(Content conversion in Receiver File adapter).
1. Here is the XML
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Emp_MT xmlns:ns0="http://sdn.com/XML_TO_CSV_01">
-
<Record>
-
<Name>David</Name>
-
<Sal>100</Sal>
-
</Record>
-
<Record>
-
<Name>Michal</Name>
-
<Sal>200</Sal>
-
</Record>
-
<Trailer>
-
<Flag>END_END</Flag>
-
</Trailer>
</ns0:Emp_MT>
2. My output need to be
David|100|
Michal|200|
END_END|
3.Content conversion
Recordset Structure = Record,*,Trailer,1
Record.endSeparator |
Record.fieldSeparator |
Trailer.endSeparator |
Trailer.fieldSeparator |
Record.addHeaderLine 0
I know I am doing wrong with CC. I went through the blog, but could not able to fix it. Can any one help me in fixing it.
Thank you
Ganges Leaves
vijaya kumari replied
Hi,
3.Content conversion
Recordset Structure = Record,*,Trailer,1
Change this to:
Recordset Structure = Record,Trailer
Regards
Vijaya