Forum Discussion

New Contributor

4 years ago

Multi 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 l...

Valued Contributor

4 years ago

Did you try using a JSON splitter already?

bourner
New Contributor
4 years ago
Hi Yes,

I’ve tried a JSON splitter.

I’ve tried to flatten both parts and then join them together. The V_Fleet xml element/objects are easy enough,

the KSSK part I’m unable to flatten

Thanks
- robin
  Former Employee
  4 years ago
  Try this pipeline (I don’t know what kind of CSV you want but it may be a start).
  
  12465_xml-to-flatten-csv_2022_05_19.slp (12.3 KB)
  
  I’m using two JSON Splitters here:
  
  and
  
  The Mapper has basic flattening rules:
  
  You’ll end up with an output that looks like this:
  
  12465_xml-to-flatten-csv_2022_05_19.slp12 KB
  - bourner
    New Contributor
    4 years ago
    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.
    
    Thanks