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
8 - Asteroid

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
8 - Asteroid
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
8 - Asteroid

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

JClinton
7 - Meteor
Spoiler
SPOILER 
 
 
 
 
 
 

 

JXEC
7 - Meteor

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

DQAUDIT
9 - Comet

Solution attached.

afnfyz
8 - Asteroid

Regex to the rescue!

Spoiler
Screenshot 2023-10-21 205904.png
RasmusFormo
8 - Asteroid

My solution :)

TopoChico
6 - Meteoroid

hello world!