AnsweredAssumed Answered

XML to CSV Conversion

Question asked by ramakrishna.ankamreddy277202 on Jul 12, 2018
Latest reply on Jul 12, 2018 by ramakrishna.ankamreddy277202

Hi Adam Arrowsmith, Srinivas Chandrakanth Vangari

I am trying to convert the file from XML to CSV, could you please assist here,

 

Input is  :

<DetailSet>
<PersonID>ZZZ</PersonID>
<Details>
<Name>AAA</Name>
<No>111</No>
</Details>
<Details>
<Name>BBB</Name>
<No>222</No>
</Details>
<Details>
<Name>CCC</Name>
<No>333</No>
</Details>
<Value>26.3</Value>
</DetailSet>

 

 

 

Output is like   :

 

PersonID,Name1,No1,Name2,No2,Name3,No3,Value
ZZZ,AAA,111,BBB,222,CCC,333,26.3

 

 

Here Name and No count is vary from request to request

 

 

Thanks in advance

Outcomes