Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #40: Parsing a HTML File

AlexC2
8 - Asteroid

My take on this:

 

jagdeep_singh85
8 - Asteroid

PFA my solution

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 40 is done, i do love regex! The expected output for the challenge seems to have an issue on row 649 (highlighted) with the practice value appearing in the city field

Spoiler
challenge 40 JMS solution.PNGError In Alteryx Expected Output.PNG
mbogusz
9 - Comet

My solution isn't perfect, but neither is the official solution.

 

Imperfections in the official solutions:

 

2019-08-31 14_14_14-Greenshot.png

 

Spoiler
2019-08-31 14_19_26-Greenshot.png
tammybrown_tds
8 - Asteroid

My solution is the same as the posted one.

 

Spoiler
Challenge 40.PNG
DanielMS
Alteryx
Alteryx
Spoiler
Capture.PNG
PhilBalderson
8 - Asteroid

Regex is king! Spotted a few errors in the solution data when I did a join to test my solution. 

JennyMartin
9 - Comet
Spoiler
AWC40.PNG

Initially tried using XML Parse, but certain doctors having multiple specialisms made this route difficult! The regex approach is definitely better here.

jusdespommes
8 - Asteroid

Love me some good old fashioned parsing 🙂

 

Spoiler
WeeklyChallenge40.PNG
wdavis
Alteryx
Alteryx

Solution Attached