We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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

atam1
7 - Meteor

I don't think RegEx is required to solve this one, but I always like to use it!

Spoiler
abanana_0-1625758696610.png

 

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1625848324954.png

Regex but not crying inside

Vanzeup7
8 - Asteroid

My solution attached. thanks.

Elias_Nordlinder
11 - Bolide

Hello,

 

My solution below (I did it in two ways as I want to learn how to do these things in different ways 🙂 )

 

Spoiler
Elias_Nordlinder_0-1626018208459.png

 

JackBurnham
8 - Asteroid

b

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-18 081348.png

carmenrapariz
8 - Asteroid
Spoiler
Challenge 22.PNG
Jotigautam
10 - Fireball

Solution

carmenrapariz
8 - Asteroid
Spoiler
Challenge 22.PNG
damian_droege
5 - Atom

Nice easter egg!

Spoiler
damian_droege_0-1628085160926.png

regex is: atm2\.(\d+(?:\.\d+)?) using the unmarked group to catch entries with no cents