The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #140: Prove the Birthday Paradox!

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

It takes long time by my misunderstanding.

 

スポイラ
Workflow
AkimasaKajitani_1-1602050081690.png

 

Macro
AkimasaKajitani_0-1602050063942.png

Output

AkimasaKajitani_2-1602050125713.png

 

 

rcarog
アステロイド

Solution attached.

mpennington
ボリード

Brute force method. Tried researching approximation methods, but failed miserably.  Wish I could've solved with an iterative macro, but not sure I could've pulled it off. Results were close to posted, but different due to trial estimation. 

 

スポイラ
MP 140 BruteForce.jpg

  

 

 

apathetichell
アルクトゥルス

and another extra output from an iterative macro...

kelsey_kincaid
12 - Quasar
12 - Quasar

Workflow:

スポイラ
kelsey_kincaid_0-1619154991706.png

 

Macro:

スポイラ
kelsey_kincaid_1-1619155026843.png

 

Graph:

kelsey_kincaid_2-1619155108777.png

 

Sashikumar
アステロイド

My Solution.

スポイラ
ch140.PNG
Thableaus
17 - Castor
17 - Castor

Loved this challenge! Had to burn my brains to set up the order of iterations and macros.

 

 

スポイラ
Thableaus_0-1623216019238.png


The fun part it took 15 min to run the workflow. I guess due to the amount of nested iterations that Alteryx had to produce.
The answers were close, but some of them differ. Although the thresholds match perfectly.

Cheers,

 

cwkoops
アステロイド

Iterative Macro...and the power of simulation. 

JasonHu
アステロイド

Here is my submission.

スポイラ
workflow.pngworkflow_macro.png
jonathanwillis
アステロイド
スポイラ
First time trying to put an iterative inside a batch macro