Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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 #176: Math Class Drill

LHolmes
9 - Comet

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
SamDesk
11 - Bolide
Spoiler
Capture.PNG

Sam 🙂

KeithZ
8 - Asteroid
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

 

kartheek31
6 - Meteoroid

After a long gap started solving challenges 😉

PeterA1
Alteryx
Alteryx
 
Pollution
6 - Meteoroid

My solve

Martyn
9 - Comet
Spoiler
clipboard_image_0.png
NickC
Alteryx Alumni (Retired)

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

JohnJPS
15 - Aurora

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

 

DavidThorpe
Alteryx
Alteryx

My solution: