Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

FeedMeData
8 - Asteroid

Great practice

Anastasiia
8 - Asteroid

Here is my solution. Parsing a HTML File is always a bit challenging for me as you need to know well the data. I also found one mistake in provided solution output file. ID 640 Wrong value in City field

Capture.JPG

Sajeel_Kershi
8 - Asteroid

another one completed

Thableaus
17 - Castor
17 - Castor

Challenge #40, done.

 

Spoiler
Challenge_40.PNG

Cheers,

cplewis90
13 - Pulsar
13 - Pulsar

My solution. I noticed when I did my first RegEx that I lost records compared to the solution so I added another section as a workaround. I am curious what others methods others used to make sure they don't lose any records from the start.

Spoiler
Challenge 40.PNG
Suzu
9 - Comet

Here is my solution.

JonathanAllenby
8 - Asteroid

Here's my solution to challenge 40!

After a bit of investigation I figured out I can pull all the correct into out in just two RegEx tools.

johnemery
11 - Bolide

Very challenging, especially for an intermediate challenge. Learning more about RegEx is great, and I attempted a secondary solution using formulas and such. Tricky tricky tricky.

arjanloogman
8 - Asteroid

My solution...

 

Had to peak a bit, took inspiration from Joe Mako's first XML parse tool (parsing <li>), went ahead from there. Missed the fact that some physicians had multiple practices, though...

 

Regards,

 

Arjan Loogman

T_Willins
14 - Magnetar
14 - Magnetar

Wanted to use RegEx, but had to parse twice to get all cities parsed. 

 

Spoiler
 Workflow 40.GIF