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 #369: Formula 1 Grand Prix (In)efficiency

mithily
8 - Asteroid
Spoiler
wrote a lovely iterative macro all by myself first answer matches exactly and my second answer is slightly less
gawa
16 - Nebula
16 - Nebula

My solution is smaller than output

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_369.JPG
Anmol97
8 - Asteroid

Here's my solution

leozhang2work
10 - Fireball

369 - 2.png369 - 1.png

michaelbono16
7 - Meteor

Tried to use do as much as possible within multi-row formula tools for efficiency

tristank
11 - Bolide

I love seeing all the different iterative macro approaches. I can't even wrap my head around some of them

 

Spoiler
Screenshot 2023-12-11 194743.pngScreenshot 2023-12-11 194733.png
sknman92
8 - Asteroid
Spoiler
 
 
Screenshot 2024-01-09 111607.png

Screenshot 2024-01-09 111637.png

My solution! Like some have noted below, my answer for number 2 is smaller than the provided answer.

raeaton
8 - Asteroid
Spoiler
Challenge_369_Solution_RE.PNG

asultanov
8 - Asteroid

The issue with the max distance limit in the Find Nearest tool still hasn't been fixed in my version of Alteryx. :(

Spoiler
But maybe that's for the best since it gives the wrong answer...
Screenshot 2024-03-05 105342.pngScreenshot 2024-03-05 105607.png