Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.

 

Spoiler
image.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
messi007
15 - Aurora
15 - Aurora

My solution :

 

Spoiler
Capture d’écran 2025-05-28 155733.png
balajilolla2
10 - Fireball
Spoiler
Solution Attached

Screenshot 2025-05-28 080536.png
abacon
12 - Quasar

I love Iterative Macros.

Spoiler
Top level workflowTop level workflowIterative MacroIterative Macro
TurboToad
11 - Bolide

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

 

 

Spoiler
image.pngimage.png

 

 

3I_ATLAS
9 - Comet

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.

Spoiler
WC_478.jpg

 

 

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-05-28 162518.pngScreenshot 2025-05-28 162523.pngScreenshot 2025-05-28 162608.png
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

Spoiler
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
9 - Comet

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.