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

Tgigs
Asteroide

My solution attached.

 

Step 1: Used regex tool to tokenize description column to rows using expression <td>([A-Za-z0-9\-{}<>\.\s]*?)<\/td>

Step 2: This results in 29 rows, first one is blank so filtered out the blank row

Step 3: Then added record ID column and split dataset into 2 based on even/odd record ID since name/value is every other

Step 4: Joined together the 2 datasets using join multiple tool based on record position

Step 5: Used select tool to clean up the dataset and put in format consistent with the provided solution

 

Not the most dynamic solution but got the job done.

danielhoge
Asteroide
Spoiler
Screenshot 2023-09-08 160054.png
caltang
17 - Castor
17 - Castor

Done!

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Computernerd
Asteroide

Funny, I thought for sure I was doing this the hard way, but the solution was very similar.

JClinton
Meteoro
Spoiler
SPOILER 
 
 
 
 
 
 

 

JXEC
Meteoro

RegEx is always tricky to work with. But this should do it.

JBLove
Bola de fuego

Solution attached.

afnfyz
Asteroide

Regex to the rescue!

Spoiler
Screenshot 2023-10-21 205904.png
RasmusFormo
Asteroide

My solution :)

TopoChico
Meteoroide

hello world!