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...
Forum Discussion
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
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:
