bourner
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Multi child xml to csv help required
Thank you so much Robin, I have an issue now that when I put in the actual xml file (17MB to 34MB in size) it keeps disconnecting. I believe its running out of memory, as I’m getting 12GB of memory allocated to this. Is there a way to just flatten the KSSK elements and ignore the V_Fleet ones ? thanks2.8KViews0likes1CommentRe: Multi child xml to csv help required
Don’t think I’m being overly clear here, apologies. What you’ve done is brilliant, I think what i need to do is pivot so that the CHARACT rows become column headings in themselves, with the VALUE as the value. So in the above image it would go AEDAT, EQASP, EQUNR, ERDAT, ERNUM, FLEET NUM, PM_ARB_A_BSTNR, PM_ARB_A_BSTPO… I’ve attached an example examplecsv.txt (456 Bytes)2.8KViews0likes1CommentRe: Multi child xml to csv help required
That’s great, I have a slight problem in that the actual xml also had some additional levels <asx:abap version=“1.0” xmlns:asx=“ABAP Development”> asx:values Example xml here </asx:values> </asx:abap> As soon as I use this xml it fails. Could you possibly point me in the right direction, and possibly explain what it’s doing ? Apologies, I’m new to SL. Thanks3.5KViews0likes1CommentMulti child xml to csv help required
HI, I have an xml file that has multiple child arrays within it. I’m struggling to get it into a flat format for export to csv, could someone spread a little snap love on this and help 🙂 xml looks like this <?xml version="1.0" encoding="utf-8"?> <FLEET> <ZMI_PM_S_OUTPUT_FLEET_LIST> <V_FLEET> <FLEET_NUM>SKBMI823EJ</FLEET_NUM> <EQUNR>000000000010014880</EQUNR> <ERDAT>2017-09-18</ERDAT> <ERNAM>DB21016</ERNAM> <EQASP>E</EQASP> <AEDAT>2021-10-01</AEDAT> </V_FLEET> <KSSK> <ZMI_PM_S_FLEET_LIST_KSSK> <KSSK_H> <OBJEK>000000000010014880</OBJEK> <MAFID>O</MAFID> <KLART>002</KLART> <CLINT>0000027802</CLINT> <ZAEHL>20</ZAEHL> <STATU>1</STATU> </KSSK_H> <AUSP> <API_VAL_R> <CHARACT>PM_ARB_A_BSTNR</CHARACT> <VALUE>10934902</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_BSTPO</CHARACT> <VALUE>140</VALUE> </API_VAL_R> </AUSP> </ZMI_PM_S_FLEET_LIST_KSSK> <ZMI_PM_S_FLEET_LIST_KSSK> <KSSK_H> <OBJEK>000000000010014880</OBJEK> <MAFID>O</MAFID> <KLART>002</KLART> <CLINT>0000027803</CLINT> <ZAEHL>10</ZAEHL> <STATU>1</STATU> </KSSK_H> <AUSP> <API_VAL_R> <CHARACT>PM_ARB_A_AC_MAN</CHARACT> <VALUE>WEBASTO ATHEMIA</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_ADVERT_FRAMES</CHARACT> <VALUE>No</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_CCTV</CHARACT> <VALUE>No</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_CURRENT_REG_DT</CHARACT> <VALUE>26.01.2017</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_EMISSIONS</CHARACT> <VALUE>16.08.2019</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_ENG_EURO_NORM</CHARACT> <VALUE>EURO VI</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_GPS</CHARACT> <VALUE>No</VALUE> </API_VAL_R> <API_VAL_R> <CHARACT>PM_ARB_A_MAN_DT</CHARACT> <VALUE>26.01.2017</VALUE> </API_VAL_R> </AUSP> </ZMI_PM_S_FLEET_LIST_KSSK> </KSSK> </ZMI_PM_S_OUTPUT_FLEET_LIST> </FLEET> if it helps “OBJEK” in <KSSK_H> is related to “EQUNR” in <V_FLEET> Many thanks7.2KViews0likes10Comments