Weekly Challenge

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

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

Submit Feedback
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.

Challenge #117: Credit/Debit Midpoints

Highlighted
Alteryx Community Team
Alteryx Community Team

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!

Highlighted
12 - Quasar
12 - Quasar

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

Highlighted
13 - Pulsar

Uploading my solution...

workflow.PNG

Highlighted
12 - Quasar
Spoiler
Challenge #117.PNG
Highlighted
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.

 

 

 

Highlighted
8 - 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.

Highlighted
8 - Asteroid

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

Highlighted
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
Highlighted
6 - Meteoroid
Spoiler
spoilertransactions.png
Highlighted
16 - Nebula
16 - Nebula

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