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 #478: Build a Coin Flip Simulation App

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

スポイラ
image.png
patrick_digan
17 - Castor
17 - Castor
スポイラ
image.png
messi007
15 - Aurora
15 - Aurora

My solution :

 

スポイラ
Capture d’écran 2025-05-28 155733.png
balajilolla2
ファイアボール
スポイラ
Solution Attached

Screenshot 2025-05-28 080536.png
abacon
パルサー

I love Iterative Macros.

スポイラ
Top level workflowTop level workflowIterative MacroIterative Macro
TurboToad
ボリード

My take on the challenge. Went with the numeric up/down interface tool instead of the text box. 

 

 

スポイラ
image.pngimage.png

 

 

3I_ATLAS
コメット

Nice macro, App practice! 

Surprisingly a macro is NOT actually needed.  if you use the RandInt function within a formula, it already provides unique random numbers for each record.  

Is that a feature or a bug?  You be the judge!  In this case we can call it a feature and use it to our own advantage.  Gives us an insight into how the RandINT and Formula tool operate.

スポイラ
WC_478.jpg

 

 

alineruizcampos
アステロイド
スポイラ
Screenshot 2025-05-28 162518.pngScreenshot 2025-05-28 162523.pngScreenshot 2025-05-28 162608.png
Yoshiro_Fujimori
16 - Nebula
16 - Nebula

My solution.

スポイラ
Considering the validation of input data, I think Numeric Up Down tool might be better than Text Input tool.

Formula Tool in Coin Flip Macro
[head] = RAND() < 0.5
[HEAD COUNT] = IF [head]  THEN [HEAD COUNT] + 1 ELSE [HEAD COUNT] ENDIF
[TAIL COUNT] = IF ![head] THEN [TAIL COUNT] + 1 ELSE [TAIL COUNT] ENDIF

Challenge478.png
mattnason1
コメット

I'm always a bit nervous with any kind of macro.  But I got it working and have the macro and the workflow with the macro separated here since I doubt the macro will flow through.  Was a lot of fun but definitely challenging.