In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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 #426: Perfect Numbers

Garrett_Stoker
8 - Asteroid
Spoiler
Screenshot 2024-05-29 112927.png
juvillalobos
7 - Meteor

 

Spoiler

perfectnumber.png

 Took me a bit to figure this one out, ended up using the Euclid-Euler Theorem, figured it was easier than using multi-row formulas I don't know. Also this formula is short, so it didn't take long. perfectnumber.png

 

tammybrown_tds
9 - Comet

This one was fun!

 

Spoiler
Screenshot 2024-05-29 160713.png
Azzo89
6 - Meteoroid

Here's my Solution Attached

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
Tofel
9 - Comet

Oh yes, should have used generate rows.

 

Spoiler
Challenge 426.JPG

Amy_smart
11 - Bolide

Here is my solution. 

nzp1
7 - Meteor
 

Attached is my version of this.

ggruccio
ACE Emeritus
ACE Emeritus

I thought about going the macro route, but then tried this!  And it worked!  (Cached the first tools to improve performance).

 

Spoiler
426.png
Reesetrain2
9 - Comet
9 - Comet

All,

 

My solution!

Spoiler
Screenshot 2024-05-30 173403.png