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 #284: Division with Macros

olga_strubbe
11 - Bolide

sorry, I forgot to attach the macro with my earlier submission.  Here it is.  Thanks,

steven_quehan
Alteryx
Alteryx

Using the old school division as we learnt at school!

griffinwelsh
12 - Quasar

Well now I have a lot less trust in the Mod function... My solution is attached. This is the first time since elementary school that I actually used long division...

le_luu
7 - Meteor
Spoiler
 
 

 Following instruction from https://www.youtube.com/watch?v=26AuFGDo5-Y

AshaDaniels
8 - Asteroid

Screenshot 2024-09-17 153453.png

Screenshot 2024-09-17 153319.png

  Potentially overcomplicated this but the solution works

Zongkai
8 - Asteroid

A great challenge to understand the algorithm we are using traditionally to divide a big number.

A great practice for iterative macro.

Bobbyt23
13 - Pulsar

Wow that was awful. It was a solution follow along for me.

martinson
11 - Bolide

Very cool challenge

Cheers,
martinson

LinkedIN

Bulien
Carolyn
12 - Quasar
12 - Quasar

Solved! I didn't realize Mod couldn't do more than Int64. This was an interesting challenge to solve around it

 

Spoiler
2025-06-09 09_59_59-Alteryx Designer x64 - challenge_284_Carolyn.yxmd.png

2025-06-09 10_00_12-Alteryx Designer x64 - Large Number Macro.yxmc.png
Erin
11 - Bolide

I took the @Watermark approach (thanks Mark!) and did this in a formula tool because I like to see everything on the screen at once vs just first loop of an iterative macro. 

 

Spoiler
284.png284 formula config.png