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.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #275: Greatest Common Denominator

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.#275_image.PNG

 

This week's challenge was submitted by @Qiu  - thanks for your submission!

 

Stuff! We all buy stuff, and sometimes we buy multiple stuffs. You might even go so far as to say we buy quantities of stuff. But beware, businesses also buy stuff and usually in larger quantities than individuals. And since they are businesses, they keep records of the stuff they buy and even analyze those records on occasion…

 

The input file for this week’s challenge contains some historic orders of two different materials. Determine the Greatest Common Denominator (GCD) of the past orders for each material to better understand any potential patterns.

patrick_digan
16 - Nebula
16 - Nebula

Here's my attempt!

Spoiler
patrick_digan_0-1625578518138.png

 

Aaron_Harter
11 - Bolide

Fun challenge!

Spoiler
0.PNG
AngelosPachis
15 - Aurora

Nice challenge to start this week. Challenge #275 is done!

 

Spoiler
AngelosPachis_0-1625578827767.png

 

DeanWest
9 - Comet

Fun challenge! 

 

Spoiler
challenge_275_solution_DeanWest-snippet-1.PNG
Spoiler
challenge_275_solution_DeanWest-snippet-2.PNG
Spoiler
challenge_275_solution_DeanWest-snippet-3.PNG
alexnajm
8 - Asteroid

Good one to start the week! My solution below:

Spoiler
challenge_275_start_file_Alex Abi-Najm.PNG
DaisukeTsuchiya
12 - Quasar

@Qiu,  Congratulations!
It's a fun challenge!

Spoiler
キャプチャ.JPG

 

 

RolandSchubert
15 - Aurora
15 - Aurora

Great challenge @Qiu !

 

Spoiler
Workflow:
W275.jpg
Iterative macro, Euclidean algorithm:

M275.jpg
PhilipMannering
14 - Magnetar
14 - Magnetar

The Eucliden Algorithm using an iterative macro for me.

 

Spoiler
1. Is mod(a,b) == 0
2a. If yes, then factor.
2b If no, a = b and b = remainder
3. repeat step 1

workflowworkflowmacromacro


And in the Python Tool

Spoiler
PhilipMannering_0-1625582489672.png

 

Maskell_Rascal
12 - Quasar

Fun challenge to start the week! Here is my solution.

 

Spoiler
Maskell_Rascal_0-1625582842373.png

 

Cheers!

Phil