Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #117: Credit/Debit Midpoints

tanyafischer
8 - Asteroid

solved :)

karlhansen
9 - Comet
Spoiler
solution_117.jpg
karlhansen
9 - Comet

With a runtime of 0.4 seconds I figured just about any efficiency would work.

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_117_KU.png
DanielG
12 - Quasar

Solved. Wow.  This was a pain in the **bleep**.  :)

 

Used an iterative macro which I am super rusty on.  Took forever to get it to work.  It is ugly but it works.  Probably very far from the most efficient way to do it, but again it works.  Spoiler shows screenshot of macro

 

Spoiler
DanielG_0-1677765030604.png

Sort Tool is useless in there, so just ignore that.  😀

leonhekkert
8 - Asteroid

Wow, this took me forever. 

 

Didnt think of the running total approach as i've now seen in many other solution.

 

Used a iterative macro inside a batch macro. Batching the accounts into an iterative macro which iterates as many times as there are transactions.

 

Spoiler
TopLayer.png
BatchMacro.jpg
IterativeMacro.png
dougbaron
8 - Asteroid

interesting challenge

Spoiler
dougbaron_0-1679603386829.png

 

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1679973533943.png
alacoume
9 - Comet

my solution:

bkclaw113
9 - Comet

I really should get more comfortable using the Running Total tool, it is just not something I go to often. Here is my batch macro approach.

Spoiler
bkclaw113_0-1681821338350.png

 

bkclaw113_1-1681821353837.png