Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam posts. As we work toward a permanent solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts. Thank you for your patience!

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 #13: HTML Table Parsing

keng
8 - Asteroid

I did something instead where I used a bunch of regex's. 

 

Came out with the same solution though! 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

wdavis
Alteryx Alumni (Retired)

Perhaps not the most dynamic workflow for other use cases, but splitting the data out initially to take out the HTML. Then splitting the records based on the Name and Values always being next to each other.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

AndrewS
11 - Bolide

#13 complete


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Inactive User
Not applicable
Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Zuza
8 - Asteroid

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

PaulN
Alteryx Alumni (Retired)

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Inactive User
Not applicable

clipboard_image_0.png


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

TonyA
Alteryx Alumni (Retired)

Here's my solution. I'm sure I could have streamlined this quite a bit. Looking forward to seeing what others have done.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

mbogusz
9 - Comet
Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

mbogusz
9 - Comet

Genius @wdavis- that's a clever solution with MOD function and filtering by evens.