Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start 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 #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.