community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #37: Parsing a Raw XML File

Asteroid

Nice XML practice

Alteryx 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

Meteor

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

Meteor
Spoiler
gn_challenge_37.png

Done with a little assistance from the provided solution :)

Alteryx 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)

37 XML (in htm).png

 

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