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

Illya
8 - Asteroid

My Solution

justindavis
10 - Fireball
Spoiler
challenge_22_solution_justindavis.PNG
SamDesk
11 - Bolide
Spoiler
Annotation 2019-11-13 121413.png

Sam

aihnen
8 - Asteroid

Solution attached.

Spoiler
Ended up using REGEX to tokenize by "/atm2.\d+\.{0,1}\d{0,2}", then used REGEX replace in order to get rid of the"/atm2." and change to a number. From there used Transpose and summed by RowNum using the Summarize tool.
aihnen_1-1573759525838.png

 

JamesCameron
8 - Asteroid

My effort.

 

Spoiler
JamesCameron_0-1574174029664.png
Rags1982
10 - Fireball
 
danicahui
8 - Asteroid
Spoiler
Challenge 22 2019-12-10.jpg
Kale_Malcom
8 - Asteroid
Spoiler
Kale_Malcom_0-1576600644210.png
Nicholas_Bignell
8 - Asteroid

Nice challenge and love that it we the original one

rmassambane
11 - Bolide