We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
Top Solution Authors