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

Alteryx
Alteryx

I took the opportunity to practice batch macros:

 

Spoiler
challenge_117_TTT.PNGchallenge_117_TTT_batch_macro.PNG

...also, thanks @NicoleJohnson for demonstrating the Make Columns tool!

Bolide
Bolide

I started working on an iterative macro, but then took that logic and built it into a regular workflow instead.

Quasar

Uploading my solution...

workflow.PNG

Quasar
Spoiler
Challenge #117.PNG
Alteryx Certified Partner

Solution attached. Given that the problem puts BEFORE and AFTER in big, bold letters I think the answer provided not completely correct. From some the solutions that I have looked at, it looks like many are adding the transaction amount itself to the Sum BEFORE and Sum AFTER. For the account 2 illustration provided, several submitted solutions were comparing a sum of 10 before/after instead of 6. In most cases this returns the correct answer, except in the case of end points. For the first transaction in any account (Trx 0), there are no DR/CR amounts before it to sum, so I do not see how it meets the required criteria given that the transaction amount itself should not be included in the sum. The same applies to the last transaction in an account where the are no amounts after to sum. In my solution, I do not include the transaction amount in the sums, so for Account 1 the end points (Trx 0 and Trx 7) get filtered out because either the sum BEFORE or the sum AFTER is null.

 

 

 

Asteroid

Where is that tool that looks like a column that I'm seeing people use?  It's orange, so I thought I'd see it with the Transform tools, but I don't?

 

Never mind.....I found it.

Asteroid

I had to take sneak peek at solutions to figure out the approach.

Spoiler
Capture.PNG
Meteoroid
Spoiler
spoilertransactions.png
Aurora
Aurora

Not even nearly as clever as @NicoleJohnson's forward & reverse solution.

 

Spoiler
- exploded this out, and used a pointer to determine the break.
- Then used two summarize tools to calculate the items on either side of the break.
- Then, in order to accommodate matches on the 0th and nth transaction - just joined it back to the fully exploded set.

2018-06-03_18-45-33.png