community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #176: Math Class Drill

Atom

Two solutions follow. Loved using the Alteryx approach to solve. Cartoon made it even better. Charge!

 

Spoiler
clipboard_image_0.png
Spoiler
clipboard_image_1.png
Bolide
Spoiler
Capture.PNG

Sam

Highlighted
Meteoroid
Spoiler

clipboard_image_0.png
Kinda cheated and started with excel spreadsheet of 100 - 999... I mean the starter did say "provide your own start data".
clipboard_image_1.png

 

Meteoroid

After a long gap started solving challenges

Alteryx
Alteryx
 
Meteoroid

My solve

Asteroid
Spoiler
clipboard_image_0.png
Alteryx
Alteryx

I'm sure there is a slicker solution, but this got me there quickly 

ACE Emeritus
ACE Emeritus

How did I miss this one-liner?

Spoiler
First, without Alteryx:

The question (in the workflow) states that 3^3 + 7^3 + 0^3 = 370...

Therefore:

3^3 + 7^3 + 0^3 +1 = 370 + 1, and since one is its own cube, and the zero is meaningless:

3^3 + 7^3 + 1^3 = 371

So... the other number we're looking for is 371.

But.. to clarify using Alteryx:

Generate rows n = 100 to n <= 999
Then filter:
n == pow(ToNumber(substring(ToString(n),0,1)),3) +
     pow(ToNumber(substring(ToString(n),1,1)),3) + 
     pow(ToNumber(substring(ToString(n),2,1)),3)

 

clipboard_image_0.png

 

Alteryx
Alteryx

My solution: