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 #40: Parsing a HTML File

Reesetrain2
9 - Comet
9 - Comet

All,

 

Spoiler
The only that I have to share is that I used a grouped ID by utilizing the Multi-row formula and then used the cross-tab to format the data.
The formula is if ([Field]="doctors") then [Row-1:ID]+1 else [Row-1:ID] endif
-Other than that, I used the Text to columns split to rows with > as the delimiter.
-Cheers!

Matt
Capture.PNG



jonathanwillis
8 - Asteroid

Here's my solution

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution:

davidhardister
8 - Asteroid

davidhardister_0-1641220448317.png

 

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1641569201076.png

 

Fun challenge

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 40.png

nikastar
6 - Meteoroid

Done!


Spoiler
Screenshot 2022-01-20 221624.png
James_Driver9
8 - Asteroid
Spoiler
James_Driver9_1-1643196460121.png

 

DataKilroy
8 - Asteroid

 

Spoiler
DataKilroy_0-1643200428543.png

 

SamSearch
7 - Meteor
Spoiler
SamSearch_0-1643277344036.png