Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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 #275: Greatest Common Denominator

KilianL
Alteryx Alumni (Retired)

No need for prime factorization - Alteryx runs over all potential divisors in 0.3 seconds!

 

スポイラ
275 - Greatest Common Denominator - Kilian.png
Sashikumar
アステロイド

Learned from Solution.

スポイラ
ch275.PNG
ryan-bush
Alteryx Alumni (Retired)

Not the most dynamic solution but fun challenge regardless!

kelly_gilbert
パルサー

For fun, using the Generate Rows tool to iterate and apply the Euclidean algorithm (instead of using a macro).

 

スポイラ
kelly_gilbert_0-1626871791472.png
lemuelcastro
ボリード

My solve!

With macro iterative and batch to Euclidean Algorithm!

lemuelcastro
ボリード

After Learning with @kelly_gilbert !

スポイラ
lemuelcastro_0-1626896637683.png

 


 

Michael_McKee
Alteryx Alumni (Retired)

A little bit Brute Force.  Could have rolled it up into a single Formula.

CRowlatt
アステロイド

I went for the brute force attack too! Still runs in less than a second.

jagdeep_singh85
アステロイド

HI 

 

PFA my solution

 

AndrewDearstyne
アトム

I can't get any simpler than this.

 

スポイラ

 

AndrewDearstyne_0-1628101879163.png