community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #117: Credit/Debit Midpoints

Meteor
 
Asteroid

The hardest part for me was understanding the request.  Once I wrapped my head around what was needed, the Alteryx workflow was pretty straightforward.

 

Spoiler

 

117.JPG

 

Alteryx Partner

I tired to do it w/o the Running Total tool but it wouldn't work w/o a long massive conditional statement.  The Running Total tool keeps the workflow code-free :)   Here is my version to the solutionCapture.PNG

Quasar

Sledgehammer approach :-) Used nasty multi formula.

 

Spoiler
2018-05-22_16-08-38.png
Alteryx Partner

I like it! My first attempt was very similar but you are a better man for sledgehammering it in to make it work. :) That switch function is sweet!

Asteroid

Here is my solution

 

Spoiler
workflow 117.JPG
Alteryx Certified Partner

Fantastic challenge. I actually struggled with this one and I feel there are better ways to do this. 

 

Spoiler
Mine is almost exactly the same as @NicoleJohnson and I must give her a shout out for having a much better solution at the beginning of the workflow with the use of the "Make Columns" tool. Mine used a clunky multi-field formula, so I stole hers. Shameless.

Anyway, I couldn't think of any other way to do this other than parsing to columns, getting a running total for each account, reversing the sorting, getting a running total the other way, then filtering those records where these running totals were equal.
Not very complex, but neither is my brain.

Workflow.PNGResults.PNG
Alteryx Partner

If the sledgehammer approach is fair game, here is mine:

 

SledgeHammer.PNG

Alteryx Certified Partner

Here is my solution using a macro. Looking now at all the nice Running Total solutions, mine looks like a monster. Also felt a bit like adding some checks to the workflow so I am checking that the total number of credits/debits against the account equals to the total number of actual transactions per account.

 

 

Spoiler

alteryx_challenge_117.pngalteryx_challenge_117_macro.png

 

Alteryx Partner

My solution, appeared to be similar to some posted earlier

Spoiler
2018-05-24_14h57_37.png