ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #22: Identify Values to Aggregate

ed_hayter
13 - Pulsar
Spoiler
ed_hayter_0-1685958444962.png

 

The_Rad_Valentina
10 - Fireball
10 - Fireball

Nice and easy one. 

bo_peng2022
8 - Asteroid

My solution

ntakeda
12 - Quasar

My solution,

Spoiler
ntakeda_0-1687248964420.png

 

mithily
8 - Asteroid
Spoiler
used text to columns and regex to solve
SamBreen
8 - Asteroid
 
Spoiler
Spolierchall 22.PNG

Computernerd
8 - Asteroid

I guess I cheated on this one as I didn't use RegEx.  After seeing the solution, I did learn a new technique.

rachel_lynch
Alteryx
Alteryx
Spoiler
Identify Values to Aggregate.png

Rachel Lynch
Towers
11 - Bolide

fun one! Love regex

Spoiler
Screenshot 2023-07-12 115425.png

olga_strubbe
11 - Bolide

Thank you, @GeneR!  This was a neat challenge - gave me an opportunity to practice RegEx. 

2023-07-12_08-31-48.png