Challenge #179: Calculating Order Status

[AYXAcademy]

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.  

[RolandSchubert]

My solution.

Spoiler

[acastelazo]

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

[andresleonm]

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

[patrick_digan]

Here's my not very concise solution:

Spoiler

[RolandSchubert]

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.

[cplewis90]

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

[hbraunius]

My solution attached.

[andresleonm]

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

Spoiler

[cgoodman3]

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