Skip to Content
0
Former Member
Jan 07, 2011 at 06:35 AM

XML to CSV Conversion

25 Views

Hi,

I have a xml file which i need to convert to CSV file.

I am able to do it for a single node but when i try to do it for 2 nodes ,then its not happening.both the rows are coming in the same line but I want it to come in separate lines.I have gone thru the sdn and sap documentation .There I could find only the properties of Content Conversion or conversion for only one node.

Could anyone help me with the content conversion parameters to be maintained on the recevier side.

Xml Input ---

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

<ns0:File2CSV_Src_MT xmlns:ns0="http://Rohit_File2CSV">

<Result>

<Student>

<Name>Rohit</Name>

<English>34</English>

<Maths>34</Maths>

<Hindi>5</Hindi>

</Student>

<Student>

<Name>Das</Name>

<English>34</English>

<Maths>34</Maths>

<Hindi>5</Hindi>

</Student>

</Result>

</ns0:File2CSV_Src_MT>

The output I want is -


Rohit,34,34,5

Das,34,34,5

Regards,

Rohit