Challenge #176: Math Class Drill

A solution to last weeks' challenge can be found here!

The end of summer is near, and it's nearly time to head back to school! Get your brain back into the swing of things with this math class drill. @KaneG found this problem in his desk on a piece of paper, and he thought it'd be heaps easier to solve in Alteryx. Is he right?

https://www.xkcd.com/1856/

challenge_176_start_file.yxmd

challenge_176_solution.yxmd

Join

Preparation

Advanced

Data Analysis

Intermediate

Transform

Accepted answers

All comments

RolandSchubert

My solution.

Spoiler

challenge_176_solution_rsc.yxmd

philipmannering

My solution. Could have pivoted also...

Spoiler

challenge_176_start_file.yxmd

David-Carnes

Fun!

Spoiler

David-Carnes_176.yxmd

NicoleJohnson

I love the smell of math in the morning.

Spoiler

My solution - 371! I like that it's only 1 off from one of the other known answers, 370. Gotta love the power of one.

Cheers!

challenge_176_NicoleJohnson.yxmd

ADerbak

Fun! Solution Attached

challenge_176_solution_AD.yxmd

bnelly1987

Great Challenge!

Spoiler

challenge_176_start_file.yxmd

viveknshah

Spoiler

challenge_176_viveknshah_soln.yxmd

danilang

And there I was ready to say "001". Doh!

Spoiler

Like @PhilipMannering and @RolandSchubert, I went for single formula solution

A very repetitive single formula

Pow(tonumber(Substring(tostring([RowCount]),0,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),1,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),2,1)),3)

Dan

challenge_176_solution_DL.yxmd

Kenda

Spoiler

My first thought was to generate numbers 0-9 then append them a couple times to get my list of possible numbers. This left 0 as a possible first number, but none of these turned out as answers so I left it as is.

challenge_176_start_file.yxmd

JORGE4900

Happy Monday; here is my solution; I added the cube superscript by inserting Alt + 0179 into the double quotes.

Spoiler

challenge_176_Jorge_Solution.yxmd

patrick_digan

Less is not more, but I went for fewer tools anyway for kicks and giggles:

Spoiler

challenge_176_Digan.yxmd

NicholasM

Good start to the week!

challenge_133_NM.yxmd

cplewis90

Fun challenge!

Spoiler

challenge_176_CL.yxmd

hbraunius

My solution.

Spoiler

challenge_176_solution_hb.yxmd

ZenonH

Very fun, lots of possible approaches for this problem (:

Spoiler

challenge_176_ZH_SOL.yxmd

PaceParillo

Spoiler

challenge_176_pparillo.yxmd

wwatson

Spoiler

challenge_176.yxmd

Claje

Neat little challenge!

Spoiler

I used some XML hacking from my Tips and Tricks post to use a RegEx tool for tokenizing on a numerical field. This is roughly pointless, but saved me a Select (or a bunch of conversion elsewhere).

claje_challenge_176_solution.yxmd

cgoodman

Spoiler

371

challenge_176_solution.yxmd

mmenth

Spoiler

challenge_176_menth_solution.yxmd

Adam_Dooley

Could be cleaner but it works!

Spoiler

challenge_176_AD.yxmd

JosephSerpis

Challenge Completed

challenge_176_Joe_Serpis.yxmd

ggruccio

Is he right? Of course he is!

challenge_176_gg_finish.yxmd

EricR

Here is my solution

challenge_176.yxmd

estherb47

Fun and fast!! And TWO TOOLS!!! Granted, that makes for an unfriendly looking filter, but sometimes it's fun to see how few tools a process needs....

Spoiler

challenge_176_EHB_completed.yxmd

ddiesel

Spoiler

Fun one!

challenge_176_end_file.yxmd

lmorrell

Spoiler

challenge_176_LM.yxmd

paul1732

My solution. Still a noob so it might be a little messy. I found it interesting that substring uses a 0 position for the first character - that one threw me off a bit.