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