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
8 - Asteroid

It's amazing to see how many different solutions are given here. Great bunch of bright people here

Highlighted
13 - Pulsar

If this were a workflow for use IRL I think I would spend more time to make it more elegant and streamlined, but this workflow should work for any data sets in this format.

 

Spoiler
Workflow 117.JPG

 

Highlighted
8 - Asteroid

Cool use of the Smart Tile tool.  Thank you @kcgreen for the inspiring solution.

 

Spoiler
2019-10-18 19_00_06-Greenshot.png
Highlighted
8 - Asteroid

Fun one!

Spoiler
challenge_116_solution_justindavis.PNG
Highlighted
8 - Asteroid

Here is my take on this one.  This one was a hard one to fully understand the problem!

 

Spoiler
bjkay30_0-1572357958535.png
Highlighted
8 - Asteroid

Solution attached.

Spoiler
18-11-2019 09-22-08.png
Highlighted
Alteryx Certified Partner

Pretty challenging tbh

Spoiler
117.jpg
Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid

My solution ended up being similar to the given solutions except I forgot about the running sum tool. Oops.

Highlighted
Alteryx Partner

The more of these I do, the more my solutions are becoming like those of the experts.  Always a good sign (even if I am not there yet) as I guess it is becoming more intuitive

 

Spoiler
Process:
- Add RecordID
- Split out even rows
- Tokenize to separate each number (\W*\d+)\s*
- Convert to number
- Take running total
- Add new RecordID
- Sort by new RecordID (desc)
- Take new running total
- Add new RecordID
- Compare running totals above and below test record
- Number Records from 0
- Change original RecordID to Account (by dividing by 2)
- Filter out Null matches
- Clean-up

MySolution.PNG