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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #179: Calculating Order Status

Meteor

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.  

 

 

Alteryx Certified Partner

My solution.

 

Spoiler
03-09-_2019_18-41-44.png
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
Meteoroid

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

Here's my not very concise solution:

Spoiler
Annotation 2019-09-03 140808.jpg
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.

Bolide

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
Asteroid

My solution attached.

Meteoroid

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

 

Spoiler
clipboard_image_0.png
Comet

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