Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #176: Math Class Drill

Highlighted
7 - Meteor

This is the first time that I actually like my solution better than the one proposed. Generate rows and tokenize.

 

Chadd

Highlighted
Alteryx Certified Partner

Interesting and funny challenge

 

Here is my solution

 

Spoiler
It seemed pretty straight forward
2019-09-18 20_35_43-Alteryx Designer x64 - challenge_176_start_file.yxmd_.png

 

But I will now go on and check the other solutions to see, if someone came up with something really cleaver.

Still Climbing
/Verakso

Highlighted
Alteryx Partner

I always enjoy the maths challenges!

Highlighted
8 - Asteroid

Thanks for the challenge! This is my solution.

Highlighted
16 - Nebula
16 - Nebula

Pretty much the same solution as @Kenda 

 

Spoiler

Flow.pngResults.png

Highlighted
Alteryx Certified Partner

Really enjoyed this one. Here's my solution. There must be a smarter way to cube than Number * Number * Number but I couldn't figure it out!

 

EDIT: here's what I should have done..

pow([Number],3)

gump.gif

Spoiler
Screenshot 2019-10-01 at 12.59.27.png

 

Highlighted
7 - Meteor

Hi,

this is my first reply to Weekly Challenge. I liked the problem and I was wondering if I could do it in Alteryx way. What naturally came to my mind was nested for ...next loop. Could you have a look at a flow and a macro I used with it and send some feed back so I can learn how to implement for ...next loops in the future?

 

The workflow below generated input to the macro. There are three digits generated independently as digit1, digit2, and digit 3. All of them are numbers starting from 0 to 9. I generate 1000 combinations.

 

 

 

challenge_176_PZ_solutionWorkFlow.JPG

The macro then takes each set of digits and calculates through the formula tool if the criteria set at the beginning are met. Before the output, the select tool takes only those numbers, for which the status is 'Success'. 

 

MathsMacro.JPG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Nice one!

 

Spoiler
It's an iterative macro which tokenizes and looks for the number which fullfills the equation

Number = number1^3+number2^3+number3^3
untitiled.png
Highlighted
8 - Asteroid
Spoiler
challenge_176_solution_justindavis.PNG
Highlighted
8 - Asteroid

It seems like there are a lot of different ways to generate your data set for this challenge. The generation of the data makes some of the solutions look more complex than they actually are.