We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #284: Division with Macros

mbogusz
9 - Comet
Spoiler
Weekly Challenge #284 in the canWeekly Challenge #284 in the can
ywang7
7 - Meteor
Spoiler
ywang7_0-1632107820705.png

 

First macro workflow!

alexnajm
8 - Asteroid

Shoutout to @PhilipMannering for helping me complete this challenge! Not easy for sure...

kelly_gilbert
12 - Quasar

My solution is pretty similar to the others, except I also implemented it with the Generate Rows tool for a no-macro solution (just for fun!) Thanks for submitting the challenge, @patrick_digan!

 

Spoiler

Like many others, I implemented long division.


Outer workflow (non-macro and macro solutions):

kelly_gilbert_1-1632326102043.png 


Iterative macro:
kelly_gilbert_0-1632326051169.png 
patrick_digan
16 - Nebula
16 - Nebula

@kelly_gilbert Very cool generate rows solutions. Reminds me of the AdventOfCode type solutions!

kelly_gilbert
12 - Quasar

@patrick_digan, yes, I totally learned that trick (from either you or @jdunkerley79) during Advent of Code 2019 😄

AdhirKirtikar
7 - Meteor

Hahahah... It's really not... "Hint: It's not 1,000,460,202,682,230,000 with remainder -442"

This one was the first answer that I got.... 😰

Really tough one, had to scratch the head intensely as I am not that good in macros yet. But finally got it after writing all the steps in excel 😬

Spoiler
challenge_284_AdhirKirtikar_ExcelWorking.png

 

Spoiler
challenge_284_AdhirKirtikar_MC.pngchallenge_284_AdhirKirtikar_WF.png

  

 

rmassambane
8 - Asteroid

another one

ArtApa
Alteryx
Alteryx

Here is my solution:

 

Spoiler
ArtApa_0-1633396072298.png

 

ArtApa_1-1633392720676.png

 

apathetichell
16 - Nebula

I know I could follow @Maskell_Rascal 's Python tool with an R big int package but the iterative macro is kind of fun.