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 #22: Identify Values to Aggregate

KMiller
8 - Asteroid

Solution attached.

Karam
8 - Asteroid

My solution :)

 

Spoiler
challenge 22.PNG
sann0638
8 - Asteroid

Just uploading ones that I have had a go at. Thanks for putting these together!

CamodCPA
8 - Asteroid

Reg ex-parse has me going crazy. It is fun to play around with it!

 

used the sample tool to skip the first n=1 rows grouped by 'field one'

 

Spoiler
Capture5.PNG
JamesMA
Alteryx Alumni (Retired)

Had a bit of trial and error with deciding the number of columns to parse to. But a fun challenge overall!

DavidCJohnson
6 - Meteoroid
 
msicak
8 - Asteroid
Spoiler
ch22.png
AlexCox
8 - Asteroid

My solution

ipeng
8 - Asteroid

Solution attached

EW
11 - Bolide

My solution with old school icons:

Spoiler
Getting more comfortable with Regex is great, but I'm still making a lot of dumb mistakes with it!

022EW.PNG