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

SamDesk
11 - Bolide
Spoiler
SamDesk_0-1584546527944.png

 

Sam

myouree
8 - Asteroid

Solution attached.

kmcdaniel
8 - Asteroid

 

Spoiler
screenshot40.png

 

 

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Spoiler
This is my solution

atcodedog05_0-1585296455688.png

 

kaianderson
8 - Asteroid

Here's my solution! Actually encompasses instances where a doctor is involved in more than one practice, as well.

aheikes
8 - Asteroid
Spoiler
Challenge40.JPG
steven4320555
8 - Asteroid

I reverse-engineered from the answer.

Spoiler
It was quite a challenge for me, but finally got there.

steven4320555_3-1586993383999.png

 

Copied the html into notepad++ for better formatting. all relevant tags, <h3>-<h5> are within <li> tag

steven4320555_0-1586988808773.png



It took me a while to figured out to "ignore the XML error and continue".

After parsing the practice <h5> tag, there were some duplications as compared to <h3> and <h4> tag. Indicating one to many relationship, so aggregation was needed. 

steven4320555_2-1586992537120.png

 


 

 

seinchyiwoo
Alteryx Alumni (Retired)

learnt a very nice trick of regex through this challenge 🙂

Spoiler
seinchyiwoo_0-1587441995683.png

 

joshuaburkhow
ACE Emeritus
ACE Emeritus

Love me some regex

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
AndrewS
11 - Bolide

#40