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 #179: Calculating Order Status

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found here

 

This week's challenge comes to us from @wwatson!  Based on a use case, this challenge recreates a real-life business problem (calculating order status) that was solved with Alteryx.

 

Thanks @wwatson for submitting this challenge! 

 

Have a great idea for a challenge?  We want to hear it!  Submit your challenge idea to our Academy Team to contribute to our Community.  

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution.

 

Spoiler
03-09-_2019_18-41-44.png
Highlighted
8 - Asteroid

There might be an error with order #8 line #12. The solution has it marked as "Partial" for the "Line Complete Status," but I argue that line is in fact complete. Just because a line is in the "Open Orders" file doesn't mean that line is partially shipped. It just means that line belongs to an order that is still open. Therefore, you have to check the shipped quantities against the ordered quantities to check the status of each line.

Spoiler
Capture.JPG
Highlighted
7 - Meteor

I was about to say that. It has to say "Order Complete Status" -> "Partial" and "Line Complete Status" -> "Line Complete".

Highlighted
15 - Aurora
15 - Aurora

Here's my not very concise solution:

Spoiler
Annotation 2019-09-03 140808.jpg
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I think, "Open Orders" lists the remaining (not yet delivered) quantity, so a line "8|12|2,H,1" in "Shipments" will be needed to fulfill the order line.

Highlighted
12 - Quasar

This was a tough one as I was able to figure out the Order Complete Status relatively quickly, but the Line Complete Status was tough and had some tricky parts. Overall fun challenge! I look forward to seeing how others finish this one. 

Spoiler
Challenge 179.PNG
Highlighted
8 - Asteroid

My solution attached.

Highlighted
7 - Meteor

Here is my solution. Please fix the challenge output in "Order Number" -> 8 "Line Number" -> 12.

 

Spoiler
clipboard_image_0.png
Highlighted
10 - Fireball

I spend longer than I'd like to admit solving this as I didn't understand why "8|12,H,1" isn't complete / complete, but worked out in the end how to get it to match the solution.

 

Spoiler
Challenge 179.PNG