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

Solved using RegEx , Row Generator and Multi Row Formula tools

Spoiler
AbhishekDoijad_1-1658166652652.png

 

paul_houghton
Quasar

Trying to remember simple maths is surprisingly harder than it should be.

 

Spoiler
Completed Long Division Macro.jpg

acarter881
Quasar

Here's my solution. I made an iterative macro to find the remainder, but I wasn't able to extend it to find the quotient.

 

I condensed and refactored some Python code I found and decided to use that to solve for both the remainder and the quotient.

Spoiler
my_weekly_challenge_284_solution.png
Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my workflow !

martinding
Pulsar
Spoiler
284.png

RWvanLeeuwen
Bolide

head scratching challenge indeed! I needed to study the solutions to get here so major kudos to the community here

Spoiler
284.png

 

JamesCharnley
Pulsar
Spoiler
JamesCharnley_5-1669756364651.png

 

JamesCharnley_1-1669748094950.png

 

 

Took me quite a long time, not helped by trying to find a ReverseString use case for a little bit too long. Could be cleaned up a bit but was just trying to match the output and get it finished

ARussell34
Asteroid

This one was brutal in my opinion, not because of the remainder but for the quotient itself.

Solution

Sapna Gupta
ahsanaali
Bolide
Spoiler
ahsanaali_0-1673881234927.pngahsanaali_1-1673881255989.png