Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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