Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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 #418: To the Nth Degree and Beyond

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Maveryx,

A solution to last week’s challenge can be found here. 

 

This challenge was submitted by Patrick Digan (@patrick_digan)  an Alteryx ACE and also an active Community member who has contributed to many challenges before. Thank you, Patrick!

 

This week’s challenge is inspired by a special day that just passed: Pi Day! Not the delicious treat, but the number with an infinite sequence of non-repeating decimals: 3.14, which is celebrated on March 14.

 

In honor of pi, this week your task is to find all 13 numbers less than or equal to 100,000 that are equal to the nth power of the sum of their digits. For example, 81 is a 2-digit number, so n=2, and (8+1)2 = 81; therefore, it falls under the category we are looking for.

 

For the input, use the Generate Rows tool to generate numbers from 0 to 100,000.

 

Bonus question: If you want to take your skills to the next level, you are invited to find all 17 numbers that are equal to any nth power of the sum of its digits. For example, 4,913 works for this. While it will fail for the first task because (4 + 9 + 1 + 3)4 = 83,521, the number 4,913 works well for the bonus question since (4 + 9 + 1 + 3)3 = 4,913.

 

Need a refresher? Review these lessons in Academy to gear up:

 

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Flo_P
9 - Comet

Definitely enjoyed this one! My solution for basic and bonus question.

 

Spoiler
image.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
スクリーンショット 2024-03-19 001331.png

binuacs
20 - Arcturus
Spoiler
image.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
alacoume
9 - Comet

Here is my solution:

Spoiler
Challenge_418.jpg
oscar_leeper_wf
7 - Meteor
Spoiler
I *finally* got an iterative macro to work!  Hopefully I can get the bonus, too.
Challenge_418_Spoiler.png
nhardin
7 - Meteor

Here's my solution for both the main task and the bonus one that doesn't use REGEx

Spoiler
Screenshot_solution_418.png
alexnajm
17 - Castor
17 - Castor

Just doing the challenge for now - the bonus maybe another day 😊

Spoiler
Challenge 418.png
ksukhraj
6 - Meteoroid

This is very efficient 👍