Challenge #37: Parsing a Raw XML File

[hanykowska]

Nice XML practice

[Verakso]

I normally dig XML, but this was my first using the XML parsing tools in Alteryx, and I am sure, with some time, I will love then ❤️

But this was hard 💔 and not that straight forward as I thought, but here it is

Spoiler

Okay, I tried to break it down into smaller pieces, but afterwards I found out, that this is not necessary.

I also tried to make the re-naming more dynamic, but that was a half-a** attempt, since I had to do some renaming in the last join anyway 😒
First attempt to parse XML

Still climbing to Lhotse Face

/Verakso

[Vidya26]

My Solution

[RobertoEstrada]

My solution, I used Dynamic Rename tool to add the column prefixes.

[dillon_bok]

Spoiler

[wdavis]

Challenge completed. Hadn't used the XML parse tool before so there was a bit of trial and error in there.

Used the Dynamic rename tool for the renaming of the fields, as opposed to the select tool

[garthn555]

Spoiler

Done with a little assistance from the provided solution 🙂

[RWvanLeeuwen]

Well this was surely nightmarish!!

The aim is to parse this horrible file structure without having the option to rely in an input data tool (or can it somehow be done to write the .yxdb to a .xml file because I was not successful in doing that)

Here is my solution (step by step manually going through all the tags until I finally brute forced my way into something that might be considered a solution (can anyone in the community build something that parses the entire thing regardless of the amount of nested tag levels?)

Spoiler

[nickjastrzebski]

A nice data clean up challenge

Spoiler

[joemkcarr]

Understand XML a lot better now - thanks for the challenge!