community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #37: Parsing a Raw XML File

Asteroid

Nice XML practice

Alteryx Certified Partner

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 
2019-05-28 09_53_34-Alteryx Designer x64 - challenge_37_solution_verakso.yxmd.pngFirst attempt to parse XML

 

Still climbing to Lhotse Face

/Verakso

Asteroid

My Solution

Asteroid

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

Asteroid
Spoiler
Weekly Challenge - 37.PNG
Alteryx
Alteryx

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

Asteroid
Spoiler
gn_challenge_37.png

Done with a little assistance from the provided solution

Alteryx Certified Partner

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

 

Alteryx Partner

A nice data clean up challenge

 

Spoiler
image.png
Alteryx Partner

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