Challenge #284: Division with Macros

AYXAcademy

A solution to last week's challenge can be found here.

This week's challenge was submitted by @patrick_digan - Thanks for your submission!

It was inspired by this post where a user was trying to get the Mod function (Modulo) to work for big numbers.

For this challenge, you will have to create a macro to divide big numbers.

So let’s try to divide 1,234,567,890,109,876,543,210 by 1,234 and produce both the quotient and remainder.

Scratching your head already?!

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

challenge_284_start_file.yxmd

challenge_284_solution.yxzp

Macros

Advanced

Difficult

Accepted answers

All comments

Maskell_Rascal

Not sure how others will solve this with the limitations of the Mod function to Int64 within Alteryx, but I would just go with Python. So here is my one tool Python solution!

Spoiler

from ayx import Package
from ayx import Alteryx
import pandas as pd

data = Alteryx.read("#1")
a = int(data['Field1'].iloc[0])
b = int(data['Field2'].iloc[0])
df = pd.DataFrame(divmod(a,b)).T
df.columns = ['answer','remainder']
result = pd.concat([data,df], axis=1,join='inner')
Alteryx.write(result,1)

Cheers!

Phil

challenge_284_Phil_Nelson.yxmd

Spalders

Spoiler

Working with a macro (modified from the one referenced in the Post)

challenge_284_ADS.yxzp

Kenda

Brutal, @patrick_digan brutal

Spoiler

I started going down a different route but I ended up with so many if statements it was getting too confusing so I started over after a peak at the linked post. Who would've thought I'd prefer long division on paper?

284.yxzp

TonyA

Didn't look at the other macro, just tried this from scratch. There has to be an easier way...

Spoiler

challenge_284_TonyA.yxzp

phottovy

Thank you to calculatorsoup for reminding me how to do long division:

Spoiler

Workflow:

Macro:

challenge_284_ph_solution.yxzp

Qiu

I feel I should get some credit for this one, since I actually provided solution to the original post. 😁

This is a rather mathmatical solution, I believe.

https://www.geeksforgeeks.org/how-to-compute-mod-of-a-big-number/

challenge_284_start_file-Qiu.yxzp

balajilolla

Spoiler

Solution Attached

challenge_284_start_file.yxzp

clmc9601

A clumsy but original solution. Thanks for the challenge!

@Qiu your solution is so elegant! Way to go.

Spoiler

With a little more work, I could convert this to an iterative macro to make it dynamic for larger numbers. It could split the incoming number into segments iteratively after every 15 characters instead of statically after the first 15 characters. It took me long enough to get the right answer that it felt like a win even without including a macro 😂

Screen Shot 2021-09-07 at 9.02.48 PM.png

Screen Shot 2021-09-07 at 9.02.48 PM.png

challenge_284_clmc9601.yxmd

RolandSchubert

Great challenge!

Spoiler

challenge_284_solution_rsc.yxzp

AkimasaKajitani

My solution.

Spoiler

challenge_284_start_file_AK.yxzp

Qiu

@clmc9601
Thank you very much for your appreciation. 😁

barnap03

Spoiler

challenge_284_barnap03.yxzp

Michael_McKee

This one was really tough. I found a great way to troubleshoot Iterative Macros. Put an output in the Macro to excel and have it append. Every loop will put the data in the spreadsheet. Thanks Tony Andriani for showing me this technique.

Spoiler

challenge_284_Solution_MM.yxmd

Division3.yxmc

DaisukeTsuchiya

Spoiler

challenge_284_start_file_DT.yxzp

kendi

I loved the challenge!!

Spoiler

challenge_284_start_file.yxzp

JasonHu

Here is my submission, solve it in 2 methods.

Non-Macro:

Spoiler

Macro:

Spoiler

challenge_284_Jason_Hu.yxzp

patrick_digan

Neat to see all of the solutions!

Spoiler

I took a very verbose/measured approach in my macros formula to basically replicate long division by hand.

Long Division.yxmc

Paul-Evans

Spoiler

It's been awhile since I made an iterative macro...

challenge_284_PE.yxzp

philipmannering

My solution,

Spoiler

Workflow,

With macro,

And in the Python Tool (Method 1)

Spoiler

Python Tool (Method 2 - the cheat way)

Spoiler

Challenge 284 - Division with Macros.yxmd

Challenge 284 - Division with Macros.yxmc

mbogusz

Spoiler

Weekly Challenge #284 in the can

challenge_284_solution_mbogusz.yxmd

ywang7

Spoiler

First macro workflow!

challenge_284_Vivian_Wang.yxzp

alexnajm

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

challenge_284_start_file_Alex Abi-Najm.yxzp

kelly_gilbert

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):

Iterative macro:

challenge_284_solution_klg.yxzp

patrick_digan

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

AdhirKirtikar

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.yxmd

challenge_284_AdhirKirtikar.yxmc

rmassambane

another one

challenge_284.yxmd

ArtApa

Here is my solution:

Spoiler

challenge_284_start_file.yxzp

apathetichell

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

challenge 284 solution.yxzp

justindavis

Spoiler

challenge_284_solution_jdavis.yxmd

DawnDuong

Thank you for posting this challenge, it is really interesting.

The most challenging aspect for me, personally, is how to make the solutions as generalised as possible, such as being able to take in unlimited number of digits and design the logic flow so that it can handle generalised the problem of adding numbers of different numbers of order of magnitudes (e.g. how to handle if the remainders when added together exceed the divisor).

I solved it using 3 iterative macros and this seems to work when tested with extra long numbers.

challenge_284_DD.yxzp

randreag

Here the challenge solved

Challenge 284 - Solved.yxzp

Sashikumar

Learned from solution.

Spoiler

challenge_284_start_file_sk.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167