Dear Experts,
I am facing issue while converting XML to CSV.
Below is the Source structure.
<Header> <Field1>ABC</Field1> <Field2>123</Field2> <Field3>XXX</Field3> <Field4>567890</Field4> <Items> <F1>ABC</F1> <F2>123</F2> <F3>XXX</F3> <F4>567890</F4> </Items> <Items> <F1>ABC</F1> <F2>12g3</F2> <F3>XXgX</F3> <F4>567fd890</F4> </Items> </Header> <Header> <Field1>654</Field1> <Field2>16d5463</Field2> <Field3>XX6d4X</Field3> <Field4>d</Field4> <Items> <F1>ABC</F1> <F2>12d3</F2> <F3>XXdX</F3> <F4>567890</F4> </Items> <Items> <F1>ABC</F1> <F2>12d3</F2> <F3>XXX</F3> <F4>567890</F4> </Items> </Header>
It is converting as
Field1,Field2,Field3,Field4
ABC,123,XXX,567890
654,16d5463,XX6d4X,d
F1,F2,F3,F4
ABC,123,XXX,567890
ABC,12g3,XXgX,567fd890
ABC,12d3,XXdX,567890
ABC,12d3,XXX,567890
I need the output as
Field1,Field2,Field3,Field4
F1,F2,F3,F4
ABC,123,XXX,567890
ABC,123,XXX,567890
ABC,12g3,XXgX,567fd890
654,16d5463,XX6d4X,d
ABC,12d3,XXdX,567890
ABC,12d3,XXX,567890
Please help me.
Thanks & Regards,
Neelima
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.