Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Assistance converting xml file to viewable table (ideally csv or excel)

jlink123
5 - Atom

Hi community,

 

I'm attempting to convert this large set of German regulator data in a tricky xml format into a useable table / csv

 

https://www.marktstammdatenregister.de/MaStR/Datendownload

 

The download itself is many independent xml files (see attached example extract for energy storage farms) 


At a first pass, it did not seem like one could drop this into alteryx and immediately parse into a table. Can folks here provide an example workflow of how to do so? Or let me know if the data cleaning process is a major headache?

 

Thanks

1 REPLY 1
AGilbert
11 - Bolide

I may be overlooking something but using the input data tool with the xml file type should parse the data based on the opening and closing header tags. 

 

xml_io.png

Labels