Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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