Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

rachel_lynch
Alteryx
Alteryx
Révélation
HTML Table Parsing.png

Rachel Lynch
mithily
Astéroïde
Révélation
spoiler tried regex but went with replace and text to rows and columns
rzdodson
Quasar
Révélation
SPOILER

Solution attached. I also went ahead and converted the workflow in to a standard macro should there be future cases where Alteryx users are doing HTML parsing. 13 - HTML TABLE PARSING WORKFLOW.png
TanbirJ99
Astéroïde

my solution Challenge13.png

 

mattnason1
Comète

Tough one, unfortunately I couldn't figure out the xml parse so read the xml and did it a bit more manually.

MatteoReddavide
Astéroïde

My solution

 

Révélation
Screenshot 2023-07-17 115520.png
olga_strubbe
Bolide

The last record appears to have some strange characters - I am not able to tell why ( .*) in RegEx formula is not able to get rid of them.  I had to write a separate formula to take care of it.  Other that that, a very nice challenge, thank you, @Gene !

2023-07-17_09-18-43.png

Amy_smart
Bolide

Here is my solution. 

H_a_n_g_C_h_e_n__x3
Astéroïde

A fun challenge

Swathi
Comète

PFA for solution